has anyone experienced this strange behaviour of mysql (3.23.49, Win2000, binary distribution) when using UPPER() and LOWER() functions with accentuated letters?
i tried to get the lower case of Á (A acute) (ISO 8859-1 code: 193) and the upper case of á (a acute) (ISO 8859-1 code: 225) and i got the following result: server started with: mysqld --standalone command line client started with: mysql if i write to the command line client this: SELECT ASCII(LOWER(CHAR(193))); i get 225 if i write to the command line client this: SELECT ASCII(UPPER(CHAR(225))); i get 225 !? so 225 is the lower case of 193 but the upper case of 225 is 225 !? however, in <MYSQL_HOME>\share\charsets\latin1.conf it is defined correctly ie 193 is the upper case of 255 and 225 is the lower case of 193 - the behaviour is even stranger if i use a non-default charset on the server eg. hungarian thanks Zsolt Szloboda --------------------------------------------------------------------- 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