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, 1811🔥, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...