NAV2009sp1 database collation problem

lombie

Hi,

I have a problem. I want the NAV2009 client to create a blank NAV database with a collation of Latin1_General_CI_AS. This is because we have many interfaces with external databases and all other databases have this collation.

The NAV2009 SP1 client creates a blank database with collation of Latin1_General_100_CI_AS when you choose
Collation Type - "Windows",
Collation Description - "Afrikaans, Basque, Catalan, Dutch, English, Faeroese, German, Indonesian, Italian, Portuguese"
Binary property - Blank,
Case-sensitive property - Blank
Accent-sensitive properties - Ticked.

Our SQL server version is MSSQL 2008 Standard and its collation is set to Latin1_General_CI_AS.
Our server OS is Server 2008 R2 Standard.

At the moment I have to create an empty database in NAV40SP2 with the options above and then open it in NAV2009SP1 and convert it to acheive the result I want. Is there a better way?

Thanks

Charles

EricS

Hi Charles,

You can change the collation in Microsoft SQL Server Management after you have created the empty database.
For this right-klick the database->properties->options. There you can change the collation before having inserted data and objects in the database.