Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
As a side note: searching google for ᔕᖺᘎᕊ is an amazing way to find sites that duplicate (legally or illegally) SO content, since @ᔕᖺᘎᕊ posts a lot but otherwise those characters don't really get used for anything.
@PatrickHofman Switch to a binary collation. Apparently SQL Server tries to be really smart when comparing strings even though I'd just like to compare two strings thank you very much. Credit for the quick fix goes to Nick Craver by the way who knew immediately why SQL Server was behaving like this.
I'm conflicted. The answer demonstrates a bad thing, and therefore should be downvoted, but it also explains the root of the problem, so it should be upvoted.
ᔕᖺᘎᕊ
is an amazing way to find sites that duplicate (legally or illegally) SO content, since @ᔕᖺᘎᕊ posts a lot but otherwise those characters don't really get used for anything.