3

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.

Cœur
  • 37,241
  • 25
  • 195
  • 267
geoaxis
  • 1,480
  • 6
  • 25
  • 46

2 Answers2

1

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.

geoaxis
  • 1,480
  • 6
  • 25
  • 46
0

Try utf8 general, and also, don't change to execute 

 SET NAMES utf8;

beore the actual query, which is quite an important part

Martin.
  • 10,494
  • 3
  • 42
  • 68
  • That doesn’t help here — in fact, it is likely the problem OP is facing. The U+25683 CJK UNIFIED IDEOGRAPH-25683 character is a supplementary Unicode symbol, and therefore cannot be stored using MySQL’s `utf8` encoding. [It needs `utf8mb4` instead.](http://mathiasbynens.be/notes/mysql-utf8mb4) – Mathias Bynens Aug 07 '12 at 06:51