On Wed, 14 Aug 2002, Ludovic GENOT wrote: > I need to make search in mysql with "accent sensitive" request. > It seems that my MySQL server (3.23.41) request are accent insensitive. > Is there an option to make mysql "accent sensitive". > > When I launch "SELECT * FROM table where name LIKE 'José';" > I just want José in the answer and not Jose !
Ludovic, what is your character set in use? (do: mysqladmin variables | less) I assume you have 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. Thomas Spahni --------------------------------------------------------------------- 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
