RE: Charset and French Diacritic Characters

2003-01-25 Thread Alliax
Hello Xavier, can't you do the transforming of your keywords before doing the query ? to transform all special characters in php it would be : $keywords = strtr($keywords,"éè^éëàãâä","_"); add other special characters and a JOKER sign in mysql '_' for each. Cheers, Damien --

Charset and French Diacritic Characters

2003-01-25 Thread Xavier LENOIR
Hello everybody, I'm french and use MySQL 3.23.40 on the Windows environment. And I have a problem with the "special french" characters (é, è, ê, à, â, etc.)... I want that the search queries are insensitive to those special characters. So that, for example, the "é" character is handled as the