5 messages in com.mysql.lists.mysqlRE: Mmultiple languages in the MySQL ...
FromSent OnAttachments
krishna27 Sep 2006 22:35 
Jerry Schwartz28 Sep 2006 06:32 
Michael Monaghan28 Sep 2006 06:57 
Jerry Schwartz28 Sep 2006 07:05 
Michael Monaghan28 Sep 2006 13:52 
Subject:RE: Mmultiple languages in the MySQL database
From:Jerry Schwartz (jsch@the-infoshop.com)
Date:09/28/2006 07:05:31 AM
List:com.mysql.lists.mysql

That's a good suggestion. As it happens, I have a web-based application that should display the data, but it doesn't. Without going into detail, all of the Chinese data is in one "account" and nothing shows in that account in the web application even though I can see the records with the MySQL client.

Now I'm chasing that hare.

Regards,

Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

-----Original Message----- From: Michael Monaghan [mailto:mick@gmail.com] Sent: Thursday, September 28, 2006 9:58 AM To: Jerry Schwartz Cc: krishna; mys@lists.mysql.com Subject: Re: Mmultiple languages in the MySQL database

On 9/28/06, Jerry Schwartz <jsch@the-infoshop.com> wrote:

We have multiple Western languages in our UTF-8 data base, without a problem. Right now I'm working on adding Chinese data, but my major problem is reading back what's in there to find out if it went in

correctly :<(

One thing I've done in the past to verify this exact issue, is to simply run something like:

# mysql -e "select fields from table" > output.txt

- making sure that the the output contains some non-ASCII characters - preferably non-Latin too.

Then open output.txt in a browser and set the character encoding to UTF-8. [View->Character Encoding->UTF-8 in Firefox].

If the content renders properly [provided you've got the right fonts obviously], then you can be sure that the content went in properly.

~mm

Regards,

Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

-----Original Message----- Wrom: DULHPQQWOYIYZUNNYCGPKYLEJGDGVCJVTLBXFGGMEPYO Sent: Thursday, September 28, 2006 1:36 AM To: mys@lists.mysql.com Subject: Mmultiple languages in the MySQL database

How do I store multiple languages in the MySQL database. Is there any configuration in MySql database server to support multilingual data. Normally if I use UTF-8 character encoding in database, it supports multiple languages. But it is not happening in MySql. Thanks Krish

-- View this message in context: http://www.nabble.com/Mmultiple-languages-in-the-MySQL-databas e-tf2348859.html#a6540543 Sent from the MySQL - General mailing list archive at Nabble.com.

-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=jsch@the-infoshop.com

-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mick@gmail.com