Mark Lewellen wrote:
Per-table or column character set support is in MySQL-4.1, which is not available in alpha form yet, but can be obtained if you're willing to install BitKeeper, download the sources from our BitKeeper tree and compile it yourself, see:In the time since this posting, has the capability of using tables with 2 different character sets been added? If so, how is it done? If not, what workarounds have people used? In case 1) above, is it feasible to have multiple servers running, each configured with a different character set? Can separate tables in the same DB be of different charsets or do entire DBs have to be of different charsets? Are there plans to add a multi-charset capability to mySQL? Are other RDBMS more appropriate for this?
http://www.mysql.com/doc/en/Installing_source_tree.html
If you have the ability to store all of your data as UTF-8, that seems to work fine with older versions of MySQL, the only issue comes when you try and use any type of collation functionality (and only with some character sets, from what I can tell), e.g, 'order by', 'between', '<', '>', etc, as these depend more on the language collation, and not necessarily the character set.
Provided solely as anecodotal evidence, I know many people who are using MySQL Connector/J to store unicode data in MySQL using the UTF-8 character encoding :)
-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
---------------------------------------------------------------------
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
