Accent insensitive?
Posted by: Marcelo Yuji Himoro
Date: June 18, 2006 07:00PM

Hi.
I've been searching for a way to how to have accent insensitiveness even with UTF-8 and read somewhere that 'utf8_general_ci' collation is accent insensitive. So, I inserted entries with some Portuguese words like 'pão', 'japonês', 'não', 'amêndoas', 'américa' and 'dívidas' encoded in UTF-8, then tried to query it for them (e.g.: %japones%), but it won't return any results.
Any ideas?

OS: Windows XP
MySQL version: 5.0.21
Collation: utf8_general_ci

(Sorry for my poor English)



Edited 1 time(s). Last edit at 06/18/2006 07:01PM by Marcelo Yuji Himoro.

Options: ReplyQuote


Subject
Views
Written By
Posted
Accent insensitive?
8343
June 18, 2006 07:00PM
3336
June 19, 2006 11:23PM


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.