MySQL utf8 issue

[mateklajos]

Hello Mysql experts. By creation of new Mysql 5.7 (28) I put Charcter set UTF8, utf8mb3, utf8mb4 and tried many collation for these. After creating this tables the field RIO is the same as RÍO, EXTREME is the same as EXTRÉMÉ and alike. For this field it can not make unique index, because these fields Mysql takes as duplicates. In Oracle, Postgresql, SQLite, MSSQL are not this issue, there is RIO and RÍO other contents, and makes the unique index. Please help me, what can be the issue. I tried for this field really many combinations of utf8, and also utf16 and 32 too, but it is the same issue. Something with vowels ???

 

[ikkeben]

Collate

How do you put/write those text in the tables.

and so more please post solution if you find

MySQL :: MySQL 8.0 Reference Manual :: 12.3.8 Character Set Introducers

dev.mysql.com

 

[wattie]

You need to use utf8_bin collation on that column.