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.
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'".