 Report Abuse |
MSSQL is case-insensitive by default
4/21/2015 12:21:08 PM
MSSQL is case-insensitive by default
SELECT name,collation_name FROM Sys.databases
Then see which suffix is used that is from https://technet.microsoft.com/en-us/library/ms180175(v=sql.105).aspx :
"CaseSensitivity
CI specifies case-insensitive, CS specifies case-sensitive.
AccentSensitivity
AI specifies accent-insensitive, AS specifies accent-sensitive."
Edit: try https://msdn.microsoft.com/en-us/library/ms143726.aspx if you need further help.
https://forums.asp.net/t/2046814.aspx?MSSQL+is+case+insensitive+by+default
|