Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 collation

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-01-04 : 09:44:01
song writes "What different between the 2 collation "SQL_Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"? I tried to import data to the DB using a customized migration tool -- it's ok for the DB with collation "SQL_Latin1_General_CP1_CI_AS" but failed for another DB with collation "SQL_Latin1_General_CI_AS". The data contains double byte characters and is in UTF-8 format. I tried to use Unicode format too."
   

- Advertisement -