SQL CE and COLLATE option ?

[Nakah]

Hi,
I want to use the COLLATE option with SqlCeEngine object, but I don't know
how ?
Is it possible to specify this option in the connection string ?

Thanks

 

[Darren Shaffer]

no, you specify/change collation options for a SQL CE database at database
creation time or during a compact operation on
the database. see SQL CE Books Online and look for keyword "COLLATE" in the
index.

Darren Shaffer
Principal Architect
Connected Innovation

 

[Nakah]

Thanks Darren,
So, it's not possible to do this with .NET ?

 

[Darren Shaffer]

oh absolutely you can do this from .Net! Through the
System.Data.SqlServerCe
namespace (the ADO.Net provider for SQL Server CE), you can set your SQL CE
collation
options either during a createdatabase or a compactdatabase command.

you may want to shift over to the microsoft.public.sqlserver.ce newsgroup
for better
coverage of this topic.

Darren Shaffer
Principal Architect
Connected Innovation