The problem of conflicts with an in the unique index field in mysql.

A dictionary database with two words ""Umbln" and "" uman" in the primary key word
report unique index conflict when inserting into the database

Duplicate entry "uman" for key "word"

the collation of the database field is utf8mb4_unicode_ci.
if changed to utf8mb4_bin, the conflict should be resolved (no attempt), but this field distinguishes between large messages. For example, if you check uman, you can"t find Umbiln

.

question: is there any way to avoid unique index conflicts without case sensitivity. Can you also search for Umbiln by typing uman?

Mar.10,2021

answer . As for the problem of , the rude approach is to create two fields, which are silly, but can be used.
one with a unique index and one for query.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b318e5-2b5ef.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b318e5-2b5ef.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?