Hello! When I run mysql with default-charset = estonia, it makes difference between upper and lower case. With latin1 charset no such distinction are made. Could someone clarify for me, is it bug?
-- Lauri Anton ( [EMAIL PROTECTED] ) ( +3727302126 ) ----- estonia ----- Server version: 3.23.49 Client characterset: latin1 Server characterset: estonia mysql> select * from a; +----+------+ | id | str | +----+------+ | 1 | AAA | | 2 | Aaa | | 3 | aaa | +----+------+ 3 rows in set (0.00 sec) mysql> select * from a where str like 'AAA'; +----+------+ | id | str | +----+------+ | 1 | AAA | +----+------+ 1 row in set (0.00 sec) ----- latin1 ------ Server version: 3.23.49 Client characterset: latin1 Server characterset: latin1 mysql> select * from a; +----+------+ | id | str | +----+------+ | 1 | AAA | | 2 | Aaa | | 3 | aaa | +----+------+ 3 rows in set (0.00 sec) mysql> select * from a where str like 'AAA'; +----+------+ | id | str | +----+------+ | 1 | AAA | | 2 | Aaa | | 3 | aaa | +----+------+ 3 rows in set (0.00 sec) --------------------------------------------------------------------- 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