When I store a file(utf8) into mysql(utf8),the field like '汉字' can't be stored correctly. But when I change the ‘汉字' to 'a汉字',which begin with a ascii char,it can be stored correctly. I use php(codeigniter) to read the file and all is configured with utf8.
Asked
Active
Viewed 19 times
0
-
try to change your column type also `utf-8-bin`. – Alive to die - Anant Jul 06 '15 at 06:44
-
[UTF-8 All the way through](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) – Mark Baker Jul 06 '15 at 07:02
-
Do you know the reason? I can't change mysql configure because the problem only occurs in product environment(I can't access it),but the code runs correctly in test environment even I does not change ’汉字' to ‘a汉字'. – Will Yun Jul 06 '15 at 07:04
-
What symptoms do you have? Question marks? Truncated text? Mojibake? Other? – Rick James Jul 07 '15 at 07:16
-
Please provide `SELECT col, HEX(col) FROM ... WHERE ...` so we can see what got stored in the table. – Rick James Jul 07 '15 at 07:17