Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Collation Changes Expand / Collapse
Author
Message
Posted Wednesday, February 17, 2010 8:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, February 17, 2010 9:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 8, 2013 9:46 AM
Points: 101, Visits: 842
because of different collation What type of issues you r facing did you found any Error Releted it.

Regards,
Shivrudra W
Post #867177
Posted Wednesday, February 17, 2010 9:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, February 18, 2010 1:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 11:16 PM
Points: 363, Visits: 1,321
You can specify the collation at database level or table level, see BOL ---> COLLATE clause
Post #867806
Posted Friday, February 19, 2010 6:59 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 10:56 AM
Points: 1,272, Visits: 2,794
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 »

Add to briefcase

Permissions Expand / Collapse