What is the encoding for the database?

Question

MySQL

In general, the task in the database is to store text with all sorts of emoticons. Googled it, set encoding from utf8 to utf8mb4. All OK. But then there was such a problem, a smile appeared: which does not want to be written to the database. This one is normal: ✅, but this one is not: *here_was_to_be_smiley_but_it_is_cut_after_publication* - incorrect value error. It is also not displayed in a text editor, but is written as \uD83D \uDCCC .
What encoding should be used for it?
PS: Oh, after posting the question here, it doesn't show up either.

Answer 1

What encoding did you change - bases, tables or columns?
\uD83D \uDCCC is a High surrogate / Low surrogate pair
10000 ₁₆ + 400 ₁₆ * (D83D ₁₆ - D800 ₁₆ ) + (DCCC ₁₆ - DC00 ₁₆ ) = 1F4CC ₁₆
"Pushpin" character,

Answer 2

Googled it, set encoding from utf8 to utf8mb4.

Check done? It should come out like this:

MariaDB [(none)]> SHOW VARIABLES  WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
+--------------------------+------------------------+
| Variable_name            | Value                  |
+--------------------------+------------------------+
| character_set_client     | utf8mb4                |
| character_set_connection | utf8mb4                |
| character_set_database   | utf8mb4                |
| character_set_filesystem | binary                 |
| character_set_results    | utf8mb4                |
| character_set_server     | utf8mb4                |
| character_set_system     | utf8                   |
| collation_connection     | utf8mb4_unicode_520_ci |
| collation_database       | utf8mb4_unicode_520_ci |
| collation_server         | utf8mb4_unicode_520_ci |
+--------------------------+------------------------+
10 rows in set (0.01 sec)