I've read that MySQL like syntax is case insensitive. I built a little search engine, but the results of LIKE 'AAA' is different of LIKE 'aaa'. Why?!? where's the problem? please help me!
Could you provide some more information such as the entire MySQL query and a description of the column (data type and example values stored within)?
-Rich
Hi Andrea!!
Mysql stores databases as directory names and tables as files, then in case sensitive os(like linux) you MUST specify table/database names with lower and upper case. In windows this makes no difference.
This \"rule\" admit exceptions! I suggest to read the manual for better explanation (http://www.mysql.com/doc/N/a/Name_case_sensitivity.html)
Ciao Paolo
I know this. I can read the manual. But i don't ask this. Tnx.
i search in a field called testo that is a longblob
could be this the problem? i do a query like this:
select * from table where testo like '%AAA%'
select * from table where testo like '%aaa%'
and the risult is different!
tnx in advance
Okay...now I see the issue.
Longblob is a binary column type. Binary columns are case sensitive.
If you convert this field into a longtext type, it will be case insensitive but will hold the information just the same.
Take a look at: http://www.mysql.com/doc/B/L/BLOB.html
Hope this helps!
