Search on words with Accentuated characters

[Laurent MIMOUN]

Hello,

My engine is myisam, and here is the paramater in my "my.ini" :

[mysql]
default-character-set=latin1

[mysqld]
default-character-set=latin1

I run queries from the command line utility "mysql" and when I run query with accentuated characters in it ('rosée', for instance), mysql doesn't return any rows.

What have I to change to make it work ?

PS : I began to do exactly the same, after recreating the base with "utf8" against "latin1" in the "my.ini" but I had the error : "Data too long for column", then for the moment I carry on using "latin1".



Edited 1 time(s). Last edit at 09/05/2006 02:47PM by Laurent MIMOUN.