Solved

If Latin1_General_CI_AS same as Latin1_General_CP1_CI_AS

Posted on 2010-08-27
2
5,152 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

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 …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

632 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