SQL CE and COLLATE option ?

  • Thread starter Thread starter Nakah
  • Start date Start date
N

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
 
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
 
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
 
Back
Top