On Mon, Oct 13, 2003 at 09:34:24PM -0700, [EMAIL PROTECTED] wrote: > Thanks, is having case insensitive by default is a normal thing?
No. Tim. > 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 >
