MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: Comparing accented characters with their closest English equivalents
Posted by: Alexander Barkov
Date: April 25, 2006 02:58AM

utf8_general_ci considers all accented letters to be equal to their non-accented base letter.
If full text does not work for you, then check LIKE. If LIKE does not work too,
then most likely something is wrong with character set configuration.
Check "SHOW CREATE TABLE" and "SHOW VARIABLES LIKE 'character_set%'".

Otherwise, if LIKE works fine, then most likely it is a fulltext bug,
feel free to report it at http://bugs.mysql.com.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Comparing accented characters with their closest English equivalents
2499
Karl Dane
March 03, 2006 10:36AM
Re: Comparing accented characters with their closest English equivalents
1704
Alexander Barkov
April 25, 2006 02:58AM


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.