February 16, 2011 at 11:13 am
Hello, can someone explain Server collation vs Database collation and is there any impact if they are different? Thank you.
Best Regards,
~David
February 16, 2011 at 11:41 am
From BOL:
SQL Server 2005 collations can be specified at any level. When you install an instance of SQL Server 2005, you specify the default collation for that instance. Each time that you create a database, you can specify the default collation used for the database. If you do not specify a collation, the default collation for the database is the default collation for the instance. Whenever you define a character column, variable, or parameter, you can specify the collation of the object. If you do not specify a collation, the object is created by using the default collation of the database.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/25b8a3da-a83b-411f-9bb9-ca684306b4d7.htm
The Redneck DBA
February 16, 2011 at 2:28 pm
Does anyone know of any issues if tempdb and your user db's collations don't match?
Best Regards,
~David
February 16, 2011 at 2:45 pm
Hi David,
Wouldn't describe it as a real issue, but obviously you would have to use COLLATE when joining string data in temp tables with string data in user DBs.
Andreas Goldman
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply