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

Article View: cn.comp.database.mysql

Article #71

Back to cn.comp.database.mysql Previous Next

#71

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

Technical Details

Message-ID: <cd873f64-b2be-4d6b-8a7c-dd82c918df90@s9g2000yqd.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!s9g2000yqd.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114450,b8b7b54f8b797b49,start
X-Google-NewGroupId: yes
X-Google-Attributes: gid4b62f1f4b2,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!s9g2000yqd.googlegroups.com!not-for-mail
From: Bill <bill_j_chen@yahoo.com>
Newsgroups: cn.comp.database.mysql
Subject: mysql command line doesn't display the chinese in the returned result 
 properly
Date: Thu, 24 Jun 2010 21:34:47 -0700 (PDT)
Organization: http://groups.google.com
Lines: 13
Message-ID: <cd873f64-b2be-4d6b-8a7c-dd82c918df90@s9g2000yqd.googlegroups.com>
NNTP-Posting-Host: 76.251.31.42
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1277440487 13874 127.0.0.1 (25 Jun 2010 04:34:47 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 25 Jun 2010 04:34:47 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: s9g2000yqd.googlegroups.com; posting-host=76.251.31.42; 
 posting-account=FqH47woAAAC2bt5vgm97VrY1hVeGKM1U
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET 
 CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152;
 .NET CLR 3.5.30729; MS-RTC LM 8; NET_mmhpset),gzip(gfe)