Search code examples
mysqlutf-8utfutf8mb4

How to save a Chinese character 𥚃 in MySQL


I am unable to save the character 𥚃 on mySQL 5.5. I have tried collation utf8mb4 and utf32. I have to store both Chinese and English characters in the same table.


Solution

  • I was able to save this charecter by using utf8mb4 charecterset on mysql server. So the output of show variables like 'char%'; should be all utf8mb4 except for perhaps system charset.