SQL Server--The default is case insensitive

SELECT * from user_info WHERE USERNAME =: USERNAME;

This way: The value of username is not case-sensitive

Cause: The collation of the database is set to Chinese_prc_ci_as, which seems to be the default value?

Processing method:

Original: 79631156

SELECT * from User_info WHERE USERNAME collate Chinese_PRC_CS_AS_WS =: USERNAME;

Add the Collate chinese_prc_cs_as_ws.

The meaning of the specific collation read: https://www.cnblogs.com/sandunban/p/7272291.html

SQL Server--The default is case insensitive