Case sensitive database using SqlCeConnection

Connection string

This .NET Compact Framework Data Provider for SQL Server Mobile connection string can be used for connections to SQL Server Compact.

Upon database creation the default is case insensitive, use this one for a case sensitive database.

Data Source=MyData.sdf;Case Sensitive=True;Persist Security Info=False;

This allows you to have multiple values, wich only deffer in lower / upper case, in a unique column.

This setting is a database creation time option and is ignored when connecting to an existing database.