Collections:
Default Collation in SQL Server Transact-SQL
How To Find Out What Is the Default Collation in SQL Server Transact-SQL?
✍: FYIcenter.com
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.
⇒ COLLATE Clause in SQL Server Transact-SQL
⇐ Collation - Character Code Page in SQL Server Transact-SQL
2017-05-13, 1906🔥, 0💬
Popular Posts:
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...