Case insensetive searches in MySQL

Anon

I'm trying to build up a search-service on a website. I've put all the content of the pages into the MySQL database(My ISP uses the 3.22.27 version), and stored them as BLOB.

I use the SQL-statement

"SELECT ... WHERE content LIKE '%$search_string%'"

I read in the manual for mysql that this search should by default be case-insensetive, but it isn't! Does anyone have a clue? What am I doing wrong??

Markus

Anon

I have had the same problem! I don't know why this happens. All I could do is to create several instances of the $search_string and manipulated it to fit possible circumstances. I.e.:
$searchUpper = strtoupper($search);
$searchCap = ucfirst($search);
And so on. It works fine, but is a little long winded.

[deleted]

if you dig a little deeper into the manual, regarding BLOB and TEXT types, you'll find this line:

-- quote --
The only difference between BLOB and TEXT types is that sorting and comparison is performed in case-sensitive fashion for BLOB values and
case-insensitive fashion for TEXT values. In other words, a TEXT is a case-insensitive BLOB.

-- end quote --

http://www.mysql.com/doc/B/L/BLOB.html

So changing your BLOB column to a TEXT column hould fix the problem.

Anon

I'll dig deeper next time...

Thanks!!

[deleted]

:-)