SanyokАнглийский символ "i" и украинский символ "і"...
Это ещё не так интересно!
А вот когда вместо "КОЛОДЯЖНЫЙ" манагер вводит "КАЛАДЯЖНЫЙ"...
Такие казусы легко обнаруживает оператор LIKE:

Так это и есть сравнение!
LIKE - это оператор сравнения:MSDNUsed to compare two strings.
Syntax
result = string Like pattern SQL Book OnlineLIKE (T-SQL)
Determines whether or not a given character string matches a specified pattern. A pattern can include regular characters and wildcard characters. During pattern matching, regular characters must exactly match the characters specified in the character string; wildcard characters, however, can be matched with arbitrary fragments of the character string. Using wildcard characters makes the LIKE operator more flexible than using the = and != string comparison operators. If any of the arguments are not of character string data type, Microsoft® SQL Server™ converts them to character string data type, if possible.
Syntax
match_expression [NOT] LIKE pattern [ESCAPE escape_character]