I have some questions about Navision Attain on SQL Server as belows: 1.What are difference issues between “Windows Collation” and “SQL Collation”? 2.Can i use Windows Collation for Navision Attain 3.6 TH? Please advise [:)]
Windows collations follow the operating system method of comparing and ordering character data; a windows collation uses the win32 function CompareString() to do this (indirectly). In this sense they closely follow comparing and ordering of the OS and other products (e.g. Excel/Access…) to give a more standard approach to this age-old problem. SQL collations are ‘lagacy’ collations from SQL Server 7.0 (and in turn from 6.5) and are individual to SQL Server, although there are still many of them and most language rules are incorporated. In terms of Attain’s use of them, currently 3.60 and prior versions can only use SQL collations - Windows collations are only possible using binary compare/ordering which does not follow any dictionary so is of limited use. The next version of Attain is supposed to support windows collations apparently. There are some ordering errors in Attain with SQL collations, for some characters in some languages, which windows collations will fix when available.