[GENERAL] Accent insensitive search

[Alejandro Javier Pomeraniec]

Hi ! Does anyone knows how to make accent insensitive searches??

For example 

i have this data in a table

--------
Colón
Polo
--------

I need that this query

SELECT * FROM testtable WHERE testfield like '%olo%';

brings both results instead of only showing Polo.

Thanks in advance! 


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])