Sign in

Microsoft.com

Microsoft

Remove From My Forums

Change CRM 4.0 Collation

Question
0

Sign in to vote

Hi guys,

For integration reasons I need to change the default Collations for my CRM 4.0 Deploy. Now the CRM Collation is Modern_Spanish_CI_AI, SQL SortOrder=0, I need change to SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52. I was wondering if this change will affect my hystoric data (retroactive) or any functionality in my CRM.

Regards..

Wednesday, April 14, 2010 8:46 PM

Answers

0

Sign in to vote
Hi Jimmy,
I wouldn't advise changing the collation of an already installed crm system. When doing select queries, etc you can always cast your collation as something else.
We had a similar situation and when we tested in a test environment did work ok, but I still would not advise it.
Alex Fagundes - www.PowerObjects.com
- Marked as answer by Jim Glass Jr Thursday, April 15, 2010 3:42 PM
Thursday, April 15, 2010 1:31 AM

All replies

0

Sign in to vote
Hi Jimmy,
I wouldn't advise changing the collation of an already installed crm system. When doing select queries, etc you can always cast your collation as something else.
We had a similar situation and when we tested in a test environment did work ok, but I still would not advise it.
Alex Fagundes - www.PowerObjects.com
- Marked as answer by Jim Glass Jr Thursday, April 15, 2010 3:42 PM
Thursday, April 15, 2010 1:31 AM
0

Sign in to vote

Thanks Alex, I will keep in mind..

Thursday, April 15, 2010 5:36 PM
0

Sign in to vote

I totally agree with Alex. I have also tried changing the collations, and something worked great, while others didn't. I really don't now the technical reason why, but i will never do this again.
Henrik Jensen Instructor / Consultant MCP, MCAD, MCSD, MCTS, MCPD, MCITP, MBSS, MBSP, MCT www.crmblog.dk and mscrm.easyconsult.dk (Danish only)

Wednesday, April 21, 2010 1:34 PM