MySQL utf8 issue


New member
Nov 19, 2019
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 ???