International Considerations (SQL Server Compact) | Microsoft Learn

Article
09/27/2010

SQL Server Compact 3.5 supports the storage and manipulation of multilingual data. Features include Unicode characters of any locale, including Chinese GB 18030 characters, and collations for sorts and comparisons.

In this section

Task	Link
Introducing collations	Working with Collations (SQL Server Compact) Supported Collations (SQL Server Compact) COLLATE (SQL Server Compact)
Creating a database with case sensitivity	How to: Create a Database by Using the Engine Object (Programmatically) How to: Create a Database by Using the Replication Object (Programmatically) Creating Databases with OLE DB How to: Create a Database by Using OLE DB (Programmatically) CreateDatabase Method (SQL Server Compact) CREATE DATABASE (SQL Server Compact)
Retrieving a database case-sensitivity setting	GetDatabaseInfo
Compacting a database with case sensitivity	How to: Compact a Database (Programmatically) CompactDatabase Method (SQL Server Compact)
Repairing a database with case sensitivity	How to: Verify and Repair a Database (Programmatically) Repair Method (SQL Server Compact)
Upgrading a database with case sensitivity	Upgrade ISSCEEngine.UpgradeDatabase (SQL Server Compact)

Other Resources

Working with Databases (SQL Server Compact)