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:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 9:58 AM > To: Jerry Schwartz > Cc: krishna; mysql@lists.mysql.com > Subject: Re: Mmultiple languages in the MySQL database > > On 9/28/06, Jerry Schwartz <[EMAIL PROTECTED]> 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: mysql@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/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
