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]

Reply via email to