I understand. Bad to hear. :-( I think there would be important to implement features to be able to set different character sets for each table, or to change character sets dynamically without the need to restart MySQL server.
This would be especially important for the ORDER BY string collations (result ordering, sorting) ... Where should I suggest this feature? Is there any place where suggestions can be sent? Thanks, Webmaster33 *********** REPLY SEPARATOR *********** On 2002.04.18 at 19:40 Victoria Reznichenko wrote: >Webmaster33, >Wednesday, April 17, 2002, 7:21:55 PM, you wrote: > >W> Anybody knows how can I change the character set, when MySQL is >running, >W> to be able to do ORDER BY using international strings? >W> I would need to do this without changing config, while I run my perl >script. > >W> I would need to do sortings for different languages. So locale >definition >W> should be changed right from within MySQL. >W> (changing locale in config is not solution, because I need to change >more >W> times for different languages) >W> How it is possible to change character set dynamically, or >W> to set different character sets for different tables within the same >database? > >Nope. Currently you need to run another instance of mysqld or restart >MySQL server to change character set. >If you use SET CHARACTER SET <character_set_name> statement you set it for >that thread >only. Currently this option supports only cp1251_koi8 for the >character_set_name. Look at: > http://www.mysql.com/doc/S/E/SET_OPTION.html > >W> Thanks in advance. >W> Best regards, >W> Webmaster33 > > > > >-- >For technical support contracts, goto https://order.mysql.com/ >This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] >/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ 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 *********** END REPLIED MESSAGE *********** --------------------------------------------------------------------- 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
