mysql htmlspecialchars(chinese) vs internal php htmlspecial chars

[ala888]

 

 

 

 

so chinese characters generated internally in php, and also via user input display fine. but ones in the mysql server cant be displayed at all with htmlspecialchars. It should also be noted that the LIKE command in mysql also does not work with chinese/japanese/korean

Edited October 7, 2014 by ala888

[justsomeguy]

I'm not sure what I'm looking at in that picture, but you basically just need to make sure that everything (the database collation, meta tag/HTTP headers, file format, etc) are all UTF. I typically haven't used htmlspecialchars to print other languages, I just output the strings directly (either directly on a page, or encoded as a JSON structure, sent to Javascript, and then added somewhere).

[ala888]

solved, the uploader client connection collation was set after the insert