sql-server-compact-supported-collations

SQL Server Compact Supported Collations

2012-08-24

Sometimes we have to search what Collation is supported by SQL Server, for example, if we know our computer system is English Windows edition , and English Visual Studio, so what the collation exactly is supported by default when you directly add a SQL Server file such as a SQL Server Compact 4.0 file ?

The following screen is caught from a Visual Studio 2010 when we tried to add a SQL Server Compact 4.0 connection, we have the option to choose a Collation, it is English-United States by default, but what is it exactly? we just remember we know something like "Latin1_General_CI_AS" when we create a database before.

So we need to search a list just like this page: Supported Collations (SQL Server Compact)

We can see the "English (United States)" is just "SQL_Latin1_General_CP1_CI_AS" which we knew. Actually "English (United States)" is Windows System Locale name, "SQL_Latin1_General_CP1_CI_AS" is the SQL Collation Name.