Posted on 2013-05-23
1) I have installed SQL Server 2008 and noticed that the default collation installed is SQL_Latin1_General_CP1_CI_AS. This collation is "not case sensitive", unlike my existing Oracle database.
May I know which collation should I choose to match (as near or close as possible) the "default" collation in Oracle?
2) Is it possible to change the collation of my new SQL database without re-installing? If yes, how?