-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ahmed S K Anis wrote:
Hi,MySQL does support non-english locales, see http://www.mysql.com/doc/en/Localisation.html
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 !!!
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
