-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 [EMAIL PROTECTED] wrote:
This problem's similar to one I posted earlier re Russian and EnglishMySQL databases prior to version 4.1 can not hold Unicode.
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?
The JDBC driver can convert Java char data to UTF-8 (which MySQL can hold as 'binary' data) to store any unicode character set in MySQL database versions prior to 4.1, but there is no collation (sorting, searching) support for UTF-8, as it's a character set that supports all locales, not a locale itself.
I am not familiar with the .net driver, so you would have to ask the authors how to store UTF-8 data with it, if possible.
-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
iD8DBQE95Nv8tvXNTca6JD8RAkqDAJ9l8G1zCR0JCJdmbXTqjwnMs9rc/wCdGeKe
Zv8QYI2TyLf5U+/lCUbop3k=
=QClc
-----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
