List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:September 28 2006 2:05pm
Subject:RE: Mmultiple languages in the MySQL database
View as plain text  
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:mickmon@stripped]
> Sent: Thursday, September 28, 2006 9:58 AM
> To: Jerry Schwartz
> Cc: krishna; mysql@stripped
> Subject: Re: Mmultiple languages in the MySQL database
>
> On 9/28/06, Jerry Schwartz <jschwartz@stripped> 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@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