Code page SQL_Latin1_General_CP1_CI_AS with Microsoft Dynamics

Our company has a database standard for our code pages, it is the Microsoft SQL Server default code page SQL_Latin1_General_CP1_CI_AS. As always we used that default code page when we installed SQL Server on one of our clusters. We recently purchased dynamics and that database is using Latin1_General_CP1_CI_AI, so we are different code pages on the server. We would like to use code page SQL_Latin1_General_CP1_CI_AS on our Dynamics database if that is possible.

I have up to three questions.

  1. Is code page SQL_Latin1_General_CP1_CI_AS supported by Microsoft Dynamics? We have been told by our Microsoft Rep that it is, but our Dynamics install does not provide for an option of using any AS code page. All the options are for the AI code pages.

The next two questions only apply if your answered yes to question 1.

  1. Why does SQL_Latin1_General_CP1_CI_AS not appear in the CRM drop down? How can we use it?

  2. What implications, if any, exist to using code page SQL_Latin1_General_CP1_CI_AS?

Mark