W3C home > Mailing lists > Public > www-international@w3.org > January to March 2004

RE: displaying Chinese and Thai characters

From: Addison Phillips [wM] <aphillips@webmethods.com>
Date: Mon, 1 Mar 2004 10:02:22 +0100
To: "Kenneth (by way of Martin Duerst <duerst@w3.org>)" <kmei1388@hotmail.com>, <www-international@w3.org>
Message-ID: <PNEHIBAMBMLHDMJDDFLHAEDAHLAA.aphillips@webmethods.com>

Hi Kenneth,

Probably your MYSQL server is not set up to store Chinese or Thai
characters. Java uses Unicode internally, while mysql can use a variety of
character encodings in its tables. You need to set the character encoding
used by your mysql server so that it can store the characters.

When you see question marks, this means that the encoding used by the
database does not include the characters you are trying to store. If you
want to store multiple langauges that use different legacy encodings in the
same database, you need to choose a Unicode encoding.

Documentation on doing this can be found on the MYSQL website here:


Best Regards,


Addison P. Phillips
Director, Globalization Architecture
webMethods | Delivering Global Business Visibility
Chair, W3C Internationalization (I18N) Working Group
Chair, W3C-I18N-WG, Web Services Task Force

Internationalization is an architecture.
It is not a feature.

> -----Original Message-----
> From: www-international-request@w3.org
> [mailto:www-international-request@w3.org]On Behalf Of Kenneth (by way of
> Martin Duerst <duerst@w3.org>)
> Sent: lundi 1 mars 2004 09:37
> To: www-international@w3.org
> Subject: displaying Chinese and Thai characters
> chinese char in mysql
> ------------------------------------------------------------------
> ----------
> ----
> hi,
> i am new in mysql. now i am trying to insert and retrieve chinese
> character
> into mysql by using Java. question mark(?) show up in the table.
> i am using
> Varchar to store the chinese character. when retrieving, question
> mark shows
> also.
> at first, i thought mysql cann't support chinese character. but it's
> impossible to say so because there are so many web site using mysql to
> display chinese character.
> i am now develope a window application. now i can connect my window
> application to mysql. i am using big5 to insert the chinese char.
> Can anyone plz tell me what steps i am missing? what should i do or
> configure to make the chinese character to display and store in proper
> format?
> kmei1388@hotmail.com
Received on Monday, 1 March 2004 04:07:16 UTC

This archive was generated by hypermail 2.4.0 : Friday, 17 January 2020 22:40:48 UTC