Andis, Thursday, August 01, 2002, 2:28:12 PM, you wrote: AG> I tested MySQL 3.23.51 under Windows and 3.23.49 under Linux RedHat 7.3 with AG> such SQL:
AG> select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS') AG> and recieved different results (of course, I used same config file with AG> case-sensitive configuration). AG> Result under Linux looks better, under window - wrong, because result AG> contain lower-case and upper-case symbols together AG> It's loks like this:'HErE I tIPED MY LaNGUaGE CHaraCtERS' AG> Now I feel confused, hov I can test, is my conf file. Strange .. on my w2k and RedHat 7.1 box I got correct results: mysql> select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS'); +----------------------------------------------------------+ | lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS') | +----------------------------------------------------------+ | here i tiped in specific my language characters | +----------------------------------------------------------+ 1 row in set (0.00 sec) What Windows do you use? How did you install MySQL from binary or from source? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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