Hi- From sections 4.6 and 2.3.3 of the mySQL manual, it appears that Chinese character encodings are supported in the v 3.23.53 binaries (traditional with 'big5' and simplified with 'gb2312' and 'gbk'). However, that discussion only lists ways in which mysqld can be configured with '--default-character-set'. Thus, there remain the questions of 1) accessing both tables in GB and tables in big5; and 2) accessing a table with columns in GB and big5. In the general mailing list archive, there is a relevant thread from August 2001:
> the table i want to create is of mixed charsets, ie: > Title VARCHAR(10), <--- Latin > desc b5 VARCHAR(10), <--- Big5 > desc gb VARCHAR(10), <--- GB2312 .... > desc en VARCHAR(10), <--- ASCII .... > desc (some other charsets...) > > I am now using a simple BINARY option to make > this (seems) possible. INSERT work fine with this. > > However, SELECT col name from tbl name > LIKE '%(somthing)%'; doesn't work as expected > with multi-byted charsets... MySQL try to match > across two characters. > > I don't want to use Unicode in this, as Unicode > is not a complete superset of all charset i have to use, > there will be some losses when i convect to other charsets.. >> Aha. so, i think nowhere. >> You can't do that. 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? Thanks very much, Mark --------------------------------------------------------------------- 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