Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 927206 - Last Review: August 15, 2007 - Revision: 2.2
A list of entries that contain Finnish or Norwegian characters is not sorted as expected in Microsoft Dynamics CRM 3.0
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:
- For the Finnish version of Microsoft Dynamics CRM 3.0, you expect the collation of the Microsoft Dynamics CRM database to be set to Finnish_Swedish_CI_AI.
- For the Norwegian version of Microsoft Dynamics CRM 3.0, you expect the collation of the Microsoft Dynamics CRM database to be set to Danish_Norwegian_CI_AS.
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:
927751Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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:
- For the Finnish version of Microsoft Dynamics CRM 3.0, transfer the Microsoft Dynamics CRM database to the Finnish_Swedish_CI_AI collation in Microsoft SQL Server.
- For the Norwegian version of Microsoft Dynamics CRM 3.0, transfer the Microsoft Dynamics CRM database to the Danish_Norwegian_CI_AS collation in Microsoft SQL Server.
For more information about how to transfer a database from one collation in Microsoft SQL Server to another collation in SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:
325335Â
(http://kbalertz.com/Feedback.aspx?kbNumber=325335/
)
How to transfer a database from one collation to another collation in SQL Server
| kbsorting kbtshoot kbmbsmigrate kbprb KB927206 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate