August 27, 2008 at 7:20 pm
I migrated some databases from MSDE 2000 to a new SQL 2005 setup, and everything went fine. When using the application that owns those databases (Dynamics GP), though, I ran into a problem, and I tracked down the cause as being the collation for the databases is LATIN1_GENERAL_CP1_CI_AS, but the default collation for the server itself is LATIN1_GENERAL_CI_AS.
Changing the collation for the databases is not an option, because they are set the way they should be. I tried changing the collation for the server, but when that didn't work, I just opted to cut my losses, reinstall, and choose LATIN1_GENERAL_CP1_CI_AS. The only problem is that I don't know which option gives me exactly LATIN1_GENERAL_CP1_CI_AS; I can specify the attributes with those checkboxes, but that's what I did the first time that gave me LATIN1_GENERAL_CI_AS.
So, my question is: what exactly do I have to choose to get LATIN1_GENERAL_CP1_CI_AS?
August 28, 2008 at 6:31 am
Hi,
Are you using SQL or Windows collations settings? It seems from your post that you are using windows collation settings which are dependent upon your windows locale. See this url http://msdn.microsoft.com/en-us/library/ms143508.aspx & this may also help http://msdn.microsoft.com/en-us/library/ms144260.aspx.
I can see a SQL collation of SQL_Latin1_General_CP1_CI_AS here http://msdn.microsoft.com/en-us/library/ms143508.aspx but nothing referring to Latin1_General_CP1_CI_AS?!
I'll keep looking!
Mark
August 28, 2008 at 6:46 am
I assume it is Windows collation, but I don't see CP1_CI_AS in this list: http://msdn.microsoft.com/en-us/library/ms143515.aspx
August 28, 2008 at 7:39 am
As a matter of interest are you based in the UK? What are the regional settings of your SQL 2005 Server? You mentioned it's a collation issue... what led you to this conclusion?
I have found some posts suggesting LATIN1_GENERAL_CP1_CI_AS & LATIN1_GENERAL_CI_AS are identical, just named differently between SQL 2000 & 2005.
September 1, 2008 at 8:01 am
Mark (8/28/2008)
As a matter of interest are you based in the UK? What are the regional settings of your SQL 2005 Server? You mentioned it's a collation issue... what led you to this conclusion?I have found some posts suggesting LATIN1_GENERAL_CP1_CI_AS & LATIN1_GENERAL_CI_AS are identical, just named differently between SQL 2000 & 2005.
No, I'm not in the UK. I did figure out the problem, though. Turns out I'm a bit of an idiot... I needed SQL_LATIN1_GENERAL_CP1_CI_AS after all. :ermm:
September 1, 2008 at 8:16 am
No, I'm not in the UK. I did figure out the problem, though. Turns out I'm a bit of an idiot... I needed SQL_LATIN1_GENERAL_CP1_CI_AS after all. :ermm:
Nevermind at least it's all sorted!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply