List:General Discussion« Previous MessageNext Message »
From:Michael Monaghan Date:September 28 2006 8:52pm
Subject:Re: Mmultiple languages in the MySQL database
View as plain text  
> > 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@stripped
> > > > 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=1
> > > >
> > > >
> > >
> > >
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=1
> > >
> > >
> >
>
>
>
>
Thread
Mmultiple languages in the MySQL databasekrishna28 Sep
  • RE: Mmultiple languages in the MySQL databaseJerry Schwartz28 Sep
    • Re: Mmultiple languages in the MySQL databaseMichael Monaghan28 Sep
      • RE: Mmultiple languages in the MySQL databaseJerry Schwartz28 Sep
        • Re: Mmultiple languages in the MySQL databaseMichael Monaghan28 Sep