Hi! This is the test table:
DROP TABLE IF EXISTS asinfo; CREATE TABLE asinfo ( asinfoID int(10) unsigned NOT NULL auto_increment, art char(1) binary NOT NULL default '', KNR char(5) NOT NULL default '', RECHNR char(6) NOT NULL default '', POSNR char(2) NOT NULL default '', ARTNR char(10) NOT NULL default '', TEX char(70) NOT NULL default '', PRIMARY KEY (asinfoID), KEY IdxArt (art), KEY IdxKnr (KNR), KEY IdxArtnr (ARTNR) ) TYPE=MyISAM; INSERT INTO asinfo VALUES (27,'j','','','','',''), [....] # there are 620 'J' and 667 'j' records. select count(*) from asinfo where upper(art) = 'J'; select count(*) from asinfo where art = 'J' or art = 'j'; select count(*) from asinfo where art = 'j' or art = 'J'; mysql OS/2 3.23.42 count(*) 1287 count(*) 620 count(*) 667 mysql linux 3.23.44 count(*) 1287 count(*) 620 count(*) 667 So the Linux version is doing it the same way. For me it's a bug in both versions. Please reply. Thanks. tam -- Ducati 750SS '92 -> on the road again http://tam.belchenstuermer.de/ Uptime 230d 22h 55m 04s --------------------------------------------------------------------- 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
