Hi guys,
Currently, i am using SQL 2K SP4 Enterprise Edtn using an Arabic collation (Server Collation: Arabic_CI_AS) for our Dynamics GP v10 SP2.
I wanted to updgrade our SQL Server to SQL 2K8 R2 Enterprise Edition and our GP to GP v2010. I had read the "System Requirements for Microsoft Dynamics GP 2010 and the all the Customer Profile server recommendations on supported MSSQL Collation are only "Dictionary Order Case Insensitive - Sort Order 52" and "Binary - Sort Order 50".
My question is, is the SORT ORDER 52 will be used during the upgrade? Is the CODE PAGE 1256 of SQL 2K is the same as SORT ORDER 52? What the SORT ORDER 144 (sql 2k8 R2)?
Many thanks.
*This post is locked for comments