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?