Herbold, John W. said:
> 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
The MS SQL server I use (old version) is NOT case sensitive.
