Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - The Default Collation in a Database

By: FYIcenter.com

(Continued from previous topic...)

How To Find Out What Is the Default Collation in a Database?

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 DATABASE FyiCenterData
GO
CREATE TABLE faq (Name VARCHAR(80))
GO
SP_HELP FAQ
GO

Column_name   ...   Collation
Name          ...   SQL_Latin1_General_CP1_CI_AS

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

(Continued on next topic...)

  1. What Is a Constant or Literal?
  2. How To Write Character String Constants or Literals?
  3. What Is a Collation?
  4. How To Specify the Collation for a Character Data Type?
  5. What Happens If Strings Are Casted into Wrong Code Pages?
  6. How To Find Out What Is the Default Collation in a Database?
  7. How Fixed Length Strings Are Truncated and Padded?
  8. How To Enter Unicode Character String Literals?
  9. How To Enter Binary String Literals?
  10. How To Enter Date and Time Literals?
  11. Why I Can Not Enter 0.001 Second in Date and Time Literals?
  12. What Happens If Date-Only Values Are Provided as Date and Time Literals?
  13. What Happens If Time-Only Values Are Provided as Date and Time Literals?
  14. What Are Out-of-Range Errors with Date and Time Literals?
  15. What Happens If an Integer Is Too Big for INT Date Type?
  16. How Extra Digits Are Handled with NUMERIC Data Type Literals?
  17. How REAL and FLOAT Literal Values Are Rounded?
  18. What Are the Underflow and Overflow Behaviors on FLOAT Literals?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...