MySQL Forums
Forum List  »  Full-Text Search

Search on words with Accentuated characters
Posted by: Laurent MIMOUN
Date: September 05, 2006 02:40PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Search on words with Accentuated characters
3405
September 05, 2006 02:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.