Selon Thomas Spahni <[EMAIL PROTECTED]>: > > what is your character set in use? (do: mysqladmin variables | less) > I assume you have latin1.
Yes, you're right, my mysql server uses latin1. > sql/share/charsets/latin1.conf maps character E8 (=é) to 45 (=E) in the > sort_order array. This is not only used for sorting; LIKE is using the > same mappings (unfortunately; there should be a separate pick_order > array because some languages want to have this distinction; others don't). > > You may try a different character set, create your own or hack > sql/share/charsets/latin1.conf and recompile. > Ok, if there isn't any other solutions, I think I will do that :) thank you for your help. Ludovic. --------------------------------------------------------------------- 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