[SOLVED] PHP Uppercase and Lower Case Problems When Using The LIKE Function

[jj20051]

I have a script setup that searches through a database of links. The problem is that if you type 'google' in nothing comes up, but if you type 'Google' in results come up. The title of the pages in the database all have a capital G at the beginning. Bellow are the two links:

 

http://apenex.net/search.php?search=google

http://apenex.net/search.php?search=Google

 

Here is the query I'm using:

 

$search = "`keywords` LIKE '%{$keyword}%' OR `title` LIKE '%{$keyword}%' OR `description` LIKE '%{$keyword}%' OR `sample` LIKE '%{$keyword}%'";

$query = "SELECT COUNT(*) as num FROM sites WHERE {$search} ORDER BY totalrating DESC";

 

 

If you have an idea, that would be great. I tried using the strtolower() function, but there was no result. I could make the whole database lowercase, but that would take a while.

[jj20051]

Apparently you can fix this by changing the table type. In my case I has it set to utf8_bin, whe i changed it to utf8_general_ci as instructed by a friend it began working.