UTF8 select collations
 

Hey, I'm trying to figure out how I can go about selecting something I have stored in a field where the string is exactly the same aside from case sensitivity and not a slight difference.

I am using utf8_general_ci but the problem is when I 'select where name = "h?ḯḯȌ" LIMIT 1' I expect to get exactly that and not a slight alteration like "hello" (first thing returned) all because a = ?,?,Ā,ǎ,Ǻ,ǻ,Ḁ etc - was looking at this

I tried to use utf8_bin, which is exactly what I want except it's case sensitive, so selecting "hello" isn't the same a "Hello". latin2_general_ci looks to be similar to what I want but I need to stick to utf8 because it seems to not have a lot of characters available that utf8 does

Is there anything I can do to have the same affect as utf8_bin but case insensitive? or preferably stick with utf8_general_ci since I like its sorting order but something I can do to my query so that an exact match is returned

thanks