Solved

If Latin1_General_CI_AS same as Latin1_General_CP1_CI_AS

Posted on 2010-08-27
2
4,938 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Parse this column 6 38
Need to find substring in SQL 5 52
SSMS Imprt data from Excel 7 38
MAC Server Managing iPad problems 2 27
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

752 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