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