Home -> Usenet -> comp.databases.mysql -> utf-8 characters not show up properly in the result of mysql> select command line

utf-8 characters not show up properly in the result of mysql> select command line

From: <bill_j_chen_at_yahoo.com>
Date: Fri, 5 Dec 2014 07:54:39 -0800 (PST)
Message-ID: <4c84a618-79e5-4704-b282-f03215eb366c_at_googlegroups.com> 






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












Original text of this message