Solved

If Latin1_General_CI_AS same as Latin1_General_CP1_CI_AS

Posted on 2010-08-27
2
4,628 Views
Last Modified: 2012-05-10
Hi;

In my SQL2000 server, my database is using Latin1_General_CP1_CI_AS collation.  Now, I need move/restore this db from SQL2000 to my new SQL2005 64 bit server, however; when I setup this new SQL2005 server, I only found the Latin1_General_CI_AS collation.  Can someone tell me are they the same?  Or, how can I find the Latin1_General_CP1_CI_AS in SL2005.

thanks!
0
Comment
Question by:KANEWONG
2 Comments
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 125 total points
ID: 33547009
They are not the same.  The first one (you probably left out "SQL_" is a SQL collation, a hangover from SQL Server 7.0.  From 2000 onwards, SQL Server started offering and using Windows code pages and collations.

See here for some discussion

http://www.developmentnow.com/g/118_2003_9_0_0_463267/how-to-change-collations-to-SQL-Latin1-General-CP1-CI-AS.htm

To use this SQL Server collation (such databases will not work with Reporting/Analysis services)

The option is there on the screen called "Collation Settings" when you install SQL Server. Choose "SQL collations", "Dictionary order, case-insensitive, for use with 1252 Character set.".
0
 
LVL 4

Assisted Solution

by:pbarry1
pbarry1 earned 125 total points
ID: 33547172
Hi,

it looks like you're using a "SQL" collation on your SQL2000 Server (SQL_Latin1_General_CP1_CI_AS).  If you want to keep this exact same collation while installing your SQL 2005 Server, you need to select the "SQL Collations" option on the "Collation Settings" installation screen.  And then select the one corresponding to SQL_Latin1_General_CP1_CI_AS (run "sp_helpsort" on your SQL 2000 Server.  It will show the details on what to use).

But to answer your question: no, these two collations are not identical.  There are slight differences between the two:

1) Latin1_General_CI_AS:  
    Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive

2) SQL_Latin1_General_CP1_CI_AS:
    Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data

Hope this helps.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
SUMMARY Enterprise backup in a heterogeneous network is a subject full of complications and restrictions. Issues such as filename & path structure, attributes and extended metadata always tend to complicate the subject to the extent where either …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question