MSSQl case sentitive?
depends on collation, default collation ends with _cs is case insensitive _cs means case
utf8_general_ci makes it case insensitive, where CI means case insensitive
Comparisons are case insensitive when the column uses a collation which ends with
_ci(such as the default
latin1_general_cicollation) and they are case sensitive when the column uses a collation which ends with
_bin(such as the