Re: Accent insensitive?

[Alexander Barkov]

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)