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

Thread View: cn.comp.database.mysql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Bill Fri, 25 Jun 2010 04:34

#71

Author: Bill
Date: Fri, 25 Jun 2010 04:34

13 lines
1654 bytes

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.

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

#72

Author: cch
Date: Wed, 01 Sep 2010 04:50

20 lines
1578 bytes

On Thu, 24 Jun 2010 21:34:47 -0700, Bill wrote:

> 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.

Have you tried latin1?


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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads