Default Collation in SQL Server Transact-SQL

Q

How To Find Out What Is the Default Collation in SQL Server Transact-SQL?

✍: FYIcenter.com

A

The default collation of a database comes from the server if you are not using the COLLATE clause in the CREATE DATABASE statement. If you are not using the COLLATE clause for character string column, it will use the default collation from the database.

Using this logic, you can find out the default collation in a database or server very easily. See the following tutorial exercise:

CREATE TABLE faq (Name VARCHAR(80))

SP_HELP FAQ
Column_name  Type     Length   Collation
-----------------------------------------------------------
Name         varchar  80       SQL_Latin1_General_CP1_CI_AS

Now we know that the default collation of SQL Server is SQL_Latin1_General_CP1_CI_AS.

 

Data Literals in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-05-13, 409👍, 0💬