MySQL_Character_Setting

    1. Show character setting

SHOW VARIABLES LIKE 'character%';

 

    2. Setting character

SET character_set_database = utf8 ;

 

    PS: However the first and second step is useless, that could be proved by login again! To solve the problem, it has to create the table with the SAME character encoding utf8.

    3. Java insert chinese into table

    There is problem when use JAVA insert chinese into MySQL table:

    To solve the problem, it has to add '?useUnicode=true&characterEncoding=utf8' in the java URL：

转载于:https://my.oschina.net/u/2363350/blog/669693