List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:August 9 1999 7:50pm
Subject:Re: mysql is case sensitive?
View as plain text  
Andrey Muratov wrote:
> 
> Oh yes. =) Just a stupid mistake...
> 
> >Sorry, but is the other way round :)
> >*BLOB and Binary fields are case sensitive the others not.
> >
> >Additionally in 3.23.2 you can use the BINARY cast on a per query basis.
> 
> Can u tell how ? No explanations only an example of query.

Hi Andrey

Simply by doing:
SELECT * FROM tableName WHERE BINARY charField = 'a%' AND charField = '%a';

This will give you a case sensitive search on "charField = 'a%'" and a case insensitive
search on "charField = '%a'".

Tschau
Christian

Thread
mysql is case sensitive?bben6 Aug
Re: mysql is case sensitive?Andrey Muratov6 Aug
  • Re: mysql is case sensitive?Christian Mack6 Aug
Re: mysql is case sensitive?Andrey Muratov9 Aug
  • Re: mysql is case sensitive?Christian Mack9 Aug