mysql - [solved]Maria DB still can't save utf8 word -


i set /etc/my.cnf.d/server.cnf

[mysqld] collation-server=utf8_unicode_ci init-connect='set names utf8' character-set-server=utf8 

and /etc/my.cnf.d/mysql-clients.cnf

[mysql] default-character-set=utf8 

and set names utf8

but still can't save chinese words

enter image description here

some chinese "characters" require 4 bytes. utf8mb4 (instead of utf8) designed them. please provide example of few chinese words not 'save', plus when try select them.

also provide

select col, hex(col) table ... 

so can see if got stored correctly. (versus being displayed incorrectly.)


Comments