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.
| Author |
Topic |
|
shahidns
Starting Member
10 Posts |
 Posted - 2005-09-20 : 07:48:31
|
| All my default installations of SQL Server have the collation SQL_Latin1_General_CPI_CI_AS. However, this morning I did another installation with all the default options, my collation is showing as Latin1_General_CPI_CI_AS. Is there any difference between these or are they the same?Thanks and regards.Shahid. |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-20 : 08:47:02
|
| The "SQL_..." prefix ones normally mean that they were originally running under a previous version of SQL Server and have been upgraded to SQL 2000.They are not the same in the sense that comparison between them directly is not allowed (I mean: in the same way that comparison between columns of different collation is not allowed). Or at least, it always seems to me that I get an error when I try to compare two columns with different collations!Kristen |
 |
|
|
|
|
|
Default collation