Monday, April 15, 2002, 10:40:06 PM, you wrote: m> I have a table with text data in English in one column, same data in m> Russian (cp1251) in another, and so on. I'd be happy to retrive that m> data sorted alphabetically according to the *respected alphabets*. I m> couldn't figure out how to perform this despite I compiled MySQL with m> alternative charsets option. Is it possible, and if yes, how? Of m> course, I can ask Perl to do this for me, but this is not an elegant m> solution, is it?
Currently you can use only one character set at a time for one instance of mysqld... If you want to use two character sets you need to restart or start another instance of mysqld. m> Thanks in advance, m> Tom -- 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