RE: MYSQL where clause case sensitive?

2003-10-14 Thread Herbold, John W.
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

RE: MYSQL where clause case sensitive?

2003-10-14 Thread William R. Mussatto
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

RE: MYSQL where clause case sensitive?

2003-10-14 Thread Michael Peppler
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

MYSQL where clause case sensitive?

2003-10-13 Thread perl
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 - eMail solutions by http://www.swanmail.com

Re: MYSQL where clause case sensitive?

2003-10-13 Thread William R. Mussatto
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

Re: MYSQL where clause case sensitive?

2003-10-13 Thread Scott R. Godin
[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

Re: MYSQL where clause case sensitive?

2003-10-13 Thread perl
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