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

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

Written By
Accent insensitive?
June 18, 2006 07:00PM
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.