To view a collation setting for a column in Object Explorer
Expand Databases, expand the database and then expand Tables. Expand the table that contains the column and then expand Columns. Right-click the column and select Properties. If the collation property is empty, the column is not a character data type.
How do I find my server collation?
You can get the server collation in SQL Server Management Studio (SSMS) by right-clicking the SQL instance, then clicking the “Properties” option and checking the “General” tab. This collation is selected by default at the installation of SQL Server.
What are collation settings?
A collation is a configuration setting that determines how the database engine should treat character data at the server, database, or column level.
