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, 1838🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...