All other DB's that I know of are case sensitive. Thanks,
John W. Herbold Jr. Security Specialist 501-399-3939 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 11:34 PM To: Scott R. Godin Cc: [EMAIL PROTECTED] Subject: Re: MYSQL where clause case sensitive? 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