Tuesday 19 July 2011

SQL Server 2008 Collation choices for Dynamics GP sort order 52

When installing Dynamics GP 2010 on a SQL Server the end collation will be based on the Regional Settings that your server is running under.

English (United Kingdom) - Latin1_General_CI_AS


English (United States) - SQL_Latin1_General_CP1_CI_AS
Both are supported to use as Sort Order 52 for Microsoft Dynamics GP 2010.  However you can run a SQL_Latin1_General_CP1_CI_AS company database on a server running Latin1_General_CI_AS


The following website link shows the language setting and the collation defined by default
http://technet.microsoft.com/en-us/library/ms143508(SQL.90).aspx

No comments:

Post a Comment