Advertisement

02.27.2007 at 04:46AM PST, ID: 22415660
[x]
Attachment Details

SQL Server 2005 SQL_Latin1_General_CP1_CI_AS collation Latin1_General_CI_AS

Asked by craigdev in SQL Server 2005, MS SQL Server

Tags: sql, sql_latin1_general_cp1_ci_as, 2005, collation, latin1_general_ci_as

I have a SQL 2000 DB with collation SQL_Latin1_General_CP1_CI_AS, I am attempting to upgrade and host this in SQL 2005 Enterprise x64 bit.

When I run the installer for SQL Server 2005 I get server collation option to install as Latin1 (which installs as Latin1_General_CI_AS) or using SQL collations to support older SQL Server versions. I have tried a few options but which SQL collation description equates to SQL_Latin1_General_CP1_CI_AS.

I need the db and server collations in the new environment to match because if I do a default install my stored procs etc fail due to collation compare issues. How do I best set this up?

ThanksStart Free Trial
[+][-]02.27.2007 at 04:56AM PST, ID: 18616345

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.27.2007 at 05:01AM PST, ID: 18616369

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, MS SQL Server
Tags: sql, sql_latin1_general_cp1_ci_as, 2005, collation, latin1_general_ci_as
Sign Up Now!
Solution Provided By: Crag
Participating Experts: 1
Solution Grade: A
 
 
[+][-]02.27.2007 at 05:03AM PST, ID: 18616382

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.27.2007 at 05:05AM PST, ID: 18616396

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.27.2007 at 05:11AM PST, ID: 18616433

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.27.2007 at 05:26AM PST, ID: 18616515

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32