What would cause this to stop working?

[youradds]

Hi,

For some reason the following SQL query doesn't want to work any more (its part of an existing program, and has worked on a million other sites);

SELECT * FROM Category WHERE Full_Name LIKE "Comercios/_pticas"

The Full_Name it should be matching has:

Comercios/Ópticas

Any ideas why this wouldn't be working?

TIA!

Andy

 

[ljzagorac]

The letter Ó makes the problem. Try
SELECT * FROM Category WHERE Full_Name LIKE "Comercios/$pticas"

 

[ljzagorac]

I meant:
SELECT * FROM Category WHERE Full_Name LIKE "Comercios/%pticas

 

[jpadie]

set the connection to use utf8,for diacritic insensitive comparisons

set names 'UTF8'

 

[youradds]

@ljzagorac - The reason I'm using _ and not %, is I only want it to match 1 character (where as % will match more than 1)

@jpadie - Thanks. It actually turned out to be an encoding issue when creating his SQL data.

Cheers

Andy