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
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
On Tue, 2003-10-14 at 09:06, William R. Mussatto wrote:
Herbold, John W. said:
All other DB's that I know of are case sensitive.
The MS SQL server I use (old version) is NOT case sensitive.
I'm almost positive that that's because a case-insensitive sort order
has been loaded. The default
is MYSQL where clause case sensitive?
it looks like it is not
redhat 9
mysql 3.23.56
name='Bob' same as name='bob'
thanks
Like most things, it depends. If you define a character column as binary
then it is case sensitive, if you do not then it is case INsensitive.
William R. Mussatto,
[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
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