Searches are access sensitive if character_set = dos

[loRdK]

I need to use character_set=dos in my server (MySQL 4.0.16).

But there is a side effect: searches become access sensitive.
So if I search for a name "José" it returns only "José" and I want it to return "Jose" and "José". This was the behaviour when I was using character_set=latin1.

Can anyone please give me a workaround for that?

Thanks.

 

[bastienk]

have you looked at soundex?


Bastien

Cat, the other other white meat

 

[loRdK]

bastienk, I cannot use soundex because I must use a "generic" sentence, which can be passed to any DBMS other than MySQL.