Article ID: 927206
This article has been archived. It is offered "as is" and will no longer be updated.
After you install the Finnish version or the Norwegian version of Microsoft Dynamics CRM 3.0, and you sort a list of entries that contain Finnish or Norwegian characters, the list of entries is not sorted as expected. Finnish or Norwegian characters include Ä, ä, Ö, ö, Å, and å.
This problem may occur if the collation of the Microsoft Dynamics CRM database is set to Latin1_General_CI_AS.
Note You expect the collation of the Microsoft Dynamics CRM database to be set to one of the following collations:
This problem is fixed in Microsoft Dynamics CRM 3.0 Update Rollup 2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/927751/ )Update Rollup 2 is available for Microsoft Dynamics CRM 3.0
To work around this problem, transfer the Microsoft Dynamics CRM database from the Latin1_General_CI_AS collation in Microsoft SQL Server, as follows:
(https://support.microsoft.com/kb/325335/ )How to transfer a database from one collation to another collation in SQL Server