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
|All times are GMT. The time now is 08:51 AM.|
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0