Page 1 of 1

why is search case sensitive here?

Posted: Thu Sep 22, 2011 8:50 am
by someguyhere

Code: Select all

	   $searchSql[] = "`company_description` LIKE '%". $wpdb->escape($_POST['keywords']) ."%'";  
When I run the search, Widegts will show up in the results, but widgets won't. What do I need to change to make it case insensitive?

Re: why is search case sensitive here?

Posted: Thu Sep 22, 2011 9:15 am
by Celauran
Check the collation in your table.

Re: why is search case sensitive here?

Posted: Thu Sep 22, 2011 9:21 am
by someguyhere
Can you be more specific? Check it for what?

Re: why is search case sensitive here?

Posted: Thu Sep 22, 2011 9:25 am
by someguyhere
Disregard, I overlooked something.