Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5672
  • Last Modified:

If Latin1_General_CI_AS same as Latin1_General_CP1_CI_AS

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
KANEWONG
Asked:
KANEWONG
2 Solutions
 
cyberkiwiCommented:
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
 
pbarry1Commented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now