SQL Server collation versus Windows collation

[Guillaume]

Hi,

i've just met a customer who have implemented Dynamics AX database with an
SQl Server collation (SQL_Latin1_General_CP1_CI_AS).
I know that Microsoft recommand tu use a WIndows collation like
Latin1_General_CI_AS for example instead.

Any idea about the risks of using SQL collation ?

Greets,

Guillaume

[Gandhinath Swaminathan [MSFT]]

Windows collations define rules for storing character data based on an
associated Windows locale. You can read about this more at
http://technet.microsoft.com/en-us/library/ms143515.aspx.

The collations dictate how the characters are sorted/compared(CI/CS - case
sensitivity, AI/AS - accent sensitivity).

SQL_Latin1_General_CP1_CI_AS is in alignment with code page 1252. The
sorting rules for this collation(SQL Server collation) will be different
from Windows collation like Latin1_General_CI_AS. Ax recommends
Latin1_General_CI_AS.

As a followup, can I ask why the customer picked
SQL_Latin1_General_CP1_CI_AS. Is there a particular reason and what is the
scenario?

--
This posting is provided "AS IS" with no warranties, and confers no rights
"Guillaume" <Guil...@discussions.microsoft.com> wrote in message
news:1D0AC213-544A-4AA0...@microsoft.com...

[Guillaume]

Hi Gandhinath,

I know what collation do and that Microsoft recommand Windows collation
rather than SQL collation for Dynamics AX.
But in a Dynamics AX point of view, i don't know if SQL Server collation
like SQL_Latin1_General_CP1_CI_AS could be a real problem for customer
implementation and what probel could occur ?
I know that SQL server collation could be a performance problem for database
with unicode and not unicode data in the same database, but all data in AX 4
is normally in Unicode, so it will may be not a problem.
Any idea of potential problems with AX and SQL server collation ?

I'm not sure that the customer know why SQL Server collation was chosen. ANd
before alerting the customer i would be necessary to have some arguments to
give him.

Greets,

[Gandhinath Swaminathan [MSFT]]

You want any application to return same comparison and sorting results. If
you choose Windows collation, an application using .NET business connector,
Ax and SQL Server would return close to similar results as opposed to being
vastly different. If you use something like SQL_Latin1_General_CP1_CI_AS,
you might get results that can be only got from SQL Server and cannot be
replicated by any other Windows application.

--
This posting is provided "AS IS" with no warranties, and confers no rights
"Guillaume" <Guil...@discussions.microsoft.com> wrote in message

news:C13EF7F7-800D-4C26...@microsoft.com...