Re: MYSQL where clause case sensitive?

From: Tim Bunce (Tim.Bunce_at_pobox.com)
Date: 10/14/03 

Date: Tue, 14 Oct 2003 10:14:19 +0100
To: perl@swanmail.com

On Mon, Oct 13, 2003 at 09:34:24PM -0700, perl@swanmail.com 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
>
> > perl@swanmail.com 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
>