This problem's similar to one I posted earlier re Russian and English characters in a database. I'm using the .net MySQLDriverCS driver. Are you saying that MySQL tables can hold unicode? If so, how do I set it up to do so? If not, how can I store Russian and English characters in MySQL? Will I have to create 2 identical databases one using the Russian characterset and the other using latin1? Can I even do this?
-----Original Message----- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: 27 November 2002 14:06 To: Ahmed S K Anis Cc: [EMAIL PROTECTED] Subject: Re: MySql on Non english locales. -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ahmed S K Anis wrote: > Hi, > I am using MySql 3.22 on a server with code page set to Japanese. > I am using MM JDBC driver. I insert english and Japanese data into a > few tables, when i query for the data from MySql i get junk > characters in place where Japanese charaters need to appear. How can i > enable MySql for Non english locales ? > Is UTF 8 supported in MySql? > > Please help me or provide information in this regard > > Thanks and Rgards, > Anis > > PS: My first query to the Mysql list, hope it doesn't dissapoint me !!! MySQL does support non-english locales, see http://www.mysql.com/doc/en/Localisation.html Multiple locales per database won't be supported until MySQL-4.1 If you are using JDBC (and you are), you can use UTF-8 to store multiple charsets in your data, just add "useUnicode=true&characterEncoding=UTF-8" to your JDBC url (this is covered in the README for the JDBC driver) -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA <___/ www.mysql.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE95NE6tvXNTca6JD8RAi5cAJ49+dxynCUpcj3ZCBIPR0HLtdNMzgCbB34E MQB5jHPHD3q1yS5zXElI6ng= =MpVd -----END PGP SIGNATURE----- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php