Hi, I am using MySQL 4.0.20. For a table of INNODB type, same query return different results when different query plan is used. select * from project_team where project_id = 'FMS '; --> 2 rows. (primary key used) select * from project_team ignore index (PRIMARY) where project_id = 'FMS '; --> 0 rows. (sequential table scan used) project_id is of type char(5) binary and is the leading part of the primary key. Since a trailing space is included in the where clause, first result should be incorrect according to MySQL documentation (which mentioned that trailing space is NOT ignored for binary comparison). Is this a bug? Also, is there a simple way to achieve : case sensitive search with trailing space ignored. (I am trying to migrate an application from SYBASE to MYSQL where the behaviour for string comparison is case sensitive and trailing space ignored). Regards, Michael
[EMAIL PROTECTED] 全港最大手機下載中心 http://mobile.yahoo.com.hk/