Mysql collation problem?

software development

#1

Until recently I had a cgi that would query the db with case insensitive queries no problem.

Some time in the past week or 2 that broke. After reading other posts I’m guessing it’s due to the mysql upgrade to 4.1.

Here’s the query that worked before:
select * from table where field like '%foo%'
and the record in the db has the field set to ‘Foo’

I have also tried:
select * from table where lower(field) like '%foo%'
and it fails to find ‘Foo’ as well

Ahhhhh, what am I missing? I read other posts that reference the fact that Collation is now set to latin1_swedish_ci but that doesn’t seem like it would cause my case problems.

Any ideas?