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

Article View: cn.comp.database.mysql

Article #72

Back to cn.comp.database.mysql Previous Next

#72

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

Technical Details

Message-ID: <i5km1t$3gm$1@adenine.netfront.net>

Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!news2.glorb.com!news.netfront.net!not-for-mail

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

Show Full Headers

Complete Article Headers

X-Google-Thread: 114450,b8b7b54f8b797b49
X-Google-NewGroupId: yes
X-Google-Attributes: gid4b62f1f4b2,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!news2.glorb.com!news.netfront.net!not-for-mail
From: "cch@srdgame" <srdgame@gmail.com>
Newsgroups: cn.comp.database.mysql
Subject: Re: mysql command line doesn't display the chinese in the returned
 result
 properly
Date: Wed, 1 Sep 2010 04:50:05 +0000 (UTC)
Organization: Netfront http://www.netfront.net/
Lines: 20
Message-ID: <i5km1t$3gm$1@adenine.netfront.net>
References: <cd873f64-b2be-4d6b-8a7c-dd82c918df90@s9g2000yqd.googlegroups.com>
NNTP-Posting-Host: 203.86.78.66
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Trace: adenine.netfront.net 1283316605 3606 203.86.78.66 (1 Sep 2010 04:50:05 GMT)
X-Complaints-To: news@netfront.net
NNTP-Posting-Date: Wed, 1 Sep 2010 04:50:05 +0000 (UTC)
User-Agent: Pan/0.133 (House of Butterflies)

Reply to Parent Message