Monday, 13 October 2008

SQL Server and database collation

The SQL Server database collation must be configured for case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive. This configuration is used to ensure file-name uniqueness consistent with the Windows operating system. For more information about collations, see "Selecting a SQL Collation" or "Collation Settings in Setup" in SQL Server Books Online.

  • Latin1_General_CI_AS_KS_WS

No comments:

Post a comment

Please include your email address with comments.