> 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.
Or alternatively there's a nice Solaris 10 utility - "auto_ef" [auto encoding-finder], to which you pass a file as a parameter and it will tell you the encoding. http://docs.sun.com/app/docs/doc/819-2246/6n4i34qee?a=view#DESCRIPTION ~mm
> > ~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]