RE: MYSQL where clause case sensitive?
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 configuration for Sybase and MS-SQL is to be case-sensitive. Michael -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] http://www.mbay.net/~mpeppler Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or long term contract positions - http://www.mbay.net/~mpeppler/resume.html
RE: MYSQL where clause case sensitive?
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.
RE: MYSQL where clause case sensitive?
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
Re: MYSQL where clause case sensitive?
On Mon, Oct 13, 2003 at 09:34:24PM -0700, [EMAIL PROTECTED] 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 > > > [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 >
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
Re: MYSQL where clause case sensitive?
[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.
Re: MYSQL where clause case sensitive?
> 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, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061
MYSQL where clause case sensitive?
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