LISCNY
asked on
SQL Server Collation
I am upgrading SQL Server 7.0 to SQL Server 2005 and have three questions.
1. What are the differences between Collations SQL_Latin1_General_CP1_CI_ AS and SQL_Latin1_General_CP437_C I_AS (tempdb on SQL 2005 Collate = SQL_Latin1_General_CP1_CI_ AS) and (SQL 7.0 database Collate = SQL_Latin1_General_CP437_C I_AS)?
2. What are the differences between Sort order ID 52 and 54?
3. Can someone demonstrate sample of SQL Query that will show how Sort order ID 52 and 54 acting?
1. What are the differences between Collations SQL_Latin1_General_CP1_CI_
2. What are the differences between Sort order ID 52 and 54?
3. Can someone demonstrate sample of SQL Query that will show how Sort order ID 52 and 54 acting?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.