March 16, 2011 at 3:54 am
Hi, I have a issue here
I install SQL Server instance collation is SQL_Latin1_General_CP1_CI_AS and this is production server NOW.
OS: Windows 2008
DB: SQL Server 2008 RC
There is 4 database all of them in production now, i need to change collation on SERVER-LEVEL not DB Level.
Change collation in server level from SQL_Latin1_General_CP1_CI_AS to Latin1_General_CI_AS.
What is different between SQL_Latin1_General_CP1_CI_AS to Latin1_General_CI_AS ?
Any help in details will be great.
thnx
New DBA
March 16, 2011 at 5:36 am
The two collations are very similar:
Latin1_General_CI_AS :- Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive
SQL_Latin1_General_CP1_CI_AS:- Latin1-General, case-insensitive,accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data
To change collation at server level, you have to run SQL Server setup:
http://msdn.microsoft.com/en-us/library/ms179254.aspx
Hope this helps
Gianluca
-- Gianluca Sartori
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply