MySQL What charset/collation for Case insensitivity and Accent sensitivity?
6
votes
2
answers
4867
views
I am looking for a charset/collation that would make it so when I do a
> SELECT * FROM table_name WHERE username = "Warrior"
It only returns me the rows where username = "Warrior", "warrior" or "WARRIOR", and not "WÂRRÎOR" "Wârrîor" etc.
I found a partial solution, by changing the Charset to "utf8mb4" and the Collation to "utf8mb4_bin", now it seems accent sensitive, it differentiates "Wârrîor" from "Warrior", but it's also case sensitive, so "Warrior" is different than "WARRIOR" which is not what I want.
I tried a different collations but I couldn't get one to do what exactly what I want. Any ideas ?
Below is a screenshot of the different Collations available to me in the "utf8mb4" Charset :

Asked by lyeaf
(307 rep)
Jun 17, 2022, 10:36 PM
Last activity: Jun 22, 2022, 02:22 AM
Last activity: Jun 22, 2022, 02:22 AM