Re: Accent insensitive?
Posted by: Alexander Barkov
Date: June 19, 2006 11:23PM

That's true, utf8_general_ci is accent insensitive.
If LIKE '%japones%' does not return 'japonês', then
you probably have some misconfiguration.

Please post results of the following queries:

- show create table your_table;
- select hex(your_column) from your_table where your_colum like 'japon%';
- show variables like 'character_set%'

(replace your_table and your_column with the actial table and column names)

Options: ReplyQuote


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