Thanks, is having case insensitive by default is a normal thing? Oracle is case sensitive by default. Does anyone knows if the DB2, MS SQLServer default behaviors?
thanks, -rkl > [EMAIL PROTECTED] wrote: > >> is MYSQL where clause case sensitive? >> it looks like it is not >> >> redhat 9 >> mysql 3.23.56 >> >> name='Bob' same as name='bob' >> > > For case-sensitivity, use the BINARY cast operator: > > select * from $table WHERE name = BINARY 'Bob'; > > will only match if it's an exact case match. > ----------------------------------------- eMail solutions by http://www.swanmail.com