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
