Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

mysql command line doesn't display the chinese in the returned result properly

4 views
Skip to first unread message

Bill

unread,
Jun 25, 2010, 12:34:47 AM6/25/10
to
I have one colum which has data in chinese.

In MySQL Workbench, the result with Chinese string show up correctly.

But when I use mysql in the command line, the chinese string is
showing up like ???A??

The COLLATION in the database side is utf8_general_ci

Does anyone know how to make the mysql command line to handle the
chinese correctly?

Thanks.

cch@srdgame

unread,
Sep 1, 2010, 12:50:05 AM9/1/10
to

Have you tried latin1?


--- news://freenews.netfront.net/ - complaints: ne...@netfront.net ---

0 new messages