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

Reply via email to