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 "e" character. and the query "élégant" finds "elegant". A very common problem I think, but until now I have no simple solution (and find nothing interesting on the Net) ! I read the MySQL manual about the charsets and their handling. It seeems that, for a given charset, sorting, "upper casing" and "lower casing" are done according to the configuration stored into the "charset.conf" file... (with the 4 arrays ctype[ ], to_lower[ ], to_upper[ ] and sort_order[ ]). By default, the charset used by my MySQL is Latin1. According to the "Latin1.conf" file (and the sort_order[ ] array), the "é" character is sorted (and compared) as the "e" character... But it does not work ! WHY ? Obviously, there is something that I don't understand, but what ? What can I do ? What should I do to obtain that the queries are insensitive to french characters ? Any help will be appreciated ! Best Regards ! Xavier LENOIR --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
