Hi! Joel is right. You can store both, however in 3.23.x and 4.0.x mysqld can use rules of the only one charset for things like GROUP BY, ORDER BY, DISTINCT, etc.
In upcoming 4.1, it's possible to have fields of different charsets at the same table. So, japanese and korean sorting will be possible even without Unicode, one needs just to create two fields: in korean and japanese charsets. All operartion with korean field will use korean collation rules. Correspindingly, all operation with japanese field will use japanese collation rules. Joel Rees wrote: >>i am working on a project in which db is mysql and it should support >>japanese and korean simultaneously I have mysql 3.23.36 running on >>red_hat_linux_7.1_sea-wolf and default ecoding for mysql is sjis >>Kindly tell meif is it possible to make a database support japanese and >>korean both languages simultaneously ???? > > I don't really know much, but from what I understand, the answer to your > question is probably not. If you want to sort and collate both at the > same time, in the same tables, you'll need the Unicode support that is > scheduled for ver. 4.1. > You can store both at the same time. > (You may have some problems with > the drivers, but it appears that those problems can be fixed or worked > around.) You can also search, if you don't care about missing a few > sometimes, or if you can write a little external code to pick up some > oddball cases. > > Or, you might consider keeping the Japanese and Korean data in separate > tables on separate servers. From what I understand, that should be possible. > > -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Alexander Barkov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia <___/ www.mysql.com +7-902-856-80-21 --------------------------------------------------------------------- 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
