Re: Select with accent sensitive request

2002-08-14 Thread Ludovic GENOT
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 no

Re: Select with accent sensitive request

2002-08-14 Thread Thomas Spahni
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