Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
I have a problem of chosing a good COLLATE for use with UNIQUE.
used the list from
SHOW COLLATION WHERE charset = 'utf8';
and everyone has some characters that count as equal.
except utf8_bin where not even "A" == "a".
So what i wanted was a case-insensitive version of utf8_bin,
a utf8_bin_ci.
A simple definition of utf8_bin_ci could be:
UPPER(name) COLLATE utf8_bin