MYSQL UTF8MB4 keep showing ???? character

Question

I would like to save extra rare Chinese character in database using mysql, however keep showing ???? after the text is inserted into the table. Previously I have searched how to insert any 4byte Chinese character into mysql data, and following the process ("Incorrect string value" when trying to insert UTF-8 into MySQL via JDBC?) but still no use. Is there something I miss?

Fyi, I have updated mysql version into 5.7.18, and I try to insert the extra rare Chinese character from phpmyadmin directly. thanks in advance!

Answer 1

As per the CREATE TABLE Syntax:

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
    (create_definition,...)
    [table_options]
    [partition_options]

[...]

table_option:
    ENGINE [=] engine_name
  | AUTO_INCREMENT [=] value
  | AVG_ROW_LENGTH [=] value
  | [DEFAULT] CHARACTER SET [=] charset_name

In other words:

CREATE TABLE test (
   some_column VARCHAR(100)
)
CHARACTER SET = utf8mb4;

It won't hurt either to pick a specific collation.

Answer 2

You also must change the connection to be utf8mb4. See http://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored for discussion of "question marks".

Note: The data failed to be stored correctly; it cannot be recovered without re-inserting the data.