SQL Server Compact Supported Collations

Published on Friday, August 24, 2012

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.

image

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.