Collation Changes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Collation Changes

Collation Changes

Rate Topic

Display Mode

Topic Options

Author

Message

robert.jackson-943581

Posted Wednesday, February 17, 2010 8:00 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 18, 2010 1:55 AM
Points: 6, Visits: 38

We have consoladated a bunch of databases on to a new SQL 2008 server. There are a wide variety of collations involved, although usually Latin1 based. The differences in collation between the databases and the servers are causing issues with old code so we are looking at standardising the collations.

What are the pro's and cons of doing this? Assuming the same CI/CS and AS settings, and staying with Latin1 I cannot see an issue with this...

For example moving Latin1_General_CI_AS on to SQL_Latin1_General_CP1_CI_AS

TIA

Rob

Post #867101

Shivrudra

Posted Wednesday, February 17, 2010 9:04 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 18, 2013 7:00 AM
Points: 99, Visits: 837

because of different collation What type of issues you r facing did you found any Error Releted it.

Regards,
Shivrudra W

Post #867177

robert.jackson-943581

Posted Wednesday, February 17, 2010 9:46 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 18, 2010 1:55 AM
Points: 6, Visits: 38

Hi,
it is when temporary tables are created because the server collation is different to the database collation. However, I've been looking at how to change the collation on the server and it is a pain. Changing the collation on the database looks easier but I'm not sure if changing the default then changes what already exists in the database, but I think not.

So... neither option looks like an easy option.

Post #867220

dmoldovan

Posted Thursday, February 18, 2010 1:45 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 4:14 AM
Points: 360, Visits: 1,261

You can specify the collation at database level or table level, see BOL ---> COLLATE clause

Post #867806

Markus

Posted Friday, February 19, 2010 6:59 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:12 AM
Points: 1,048, Visits: 2,217

The only way to change the database collation is to create a new db with the different collation and then move the objects and data into it. There is no easy way to change collations in an existing db.

Post #869047

« Prev Topic | Next Topic »

Permissions