I have a webserver which we can input the book title, book description etc. The data is saved into a mysql database and table columns has collation "utf8_general_ci".
In book infomration show up in the webpage (using character set utf8) correctly when I use the webpage to search the books.
But I have some issue when query the database using mysql client (command line). The any entry with chinese (utf8) shows up scrambled.
I made sure that my fedora 20 can handle and display utf8 chinese correctly in command line. and mysql > show VARIABLES like 'char%'; returns:
character_set_client utf8
character_set_connection utf8
character_set_result utf8
character_set_system utf8
Actually I run the mysql select command in the same machine hosting the webserver and mysql databas, which is fedora 20. In the fedora shell, I can vi, cat any utf8 file without problem.
I don't know what elese I missed.
Another question - do we have way to get the value of the booktitle byte by byte? then at least I can see what value stored inside table, that might give me some idea.
Thanks.
Received on Fri Dec 05 2014 - 16:54:39 CET