Welcome Guest
Login Register
 
MSSQL is case-insensitive by default
 
0 Reply's, Recent Post by Tech on 4/21/2015 12:21:08 PM
   

Previous Thread     Next Thread

Tech
9 Points
51 Posts
Guest Reply      Reply            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


Post Your Comment        
   Previous Thread     Next Thread
Guest Reply