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

Beware of Mixing Collations: Converting Collations Expand / Collapse
Posted Sunday, December 29, 2002 12:00 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:41 AM
Points: 1,040, Visits: 285
Comments posted to this topic are about the content posted at

Gregory A. Larsen, MVP
Post #9014
Posted Monday, January 6, 2003 10:34 AM


Group: General Forum Members
Last Login: Thursday, October 4, 2007 10:09 AM
Points: 198, Visits: 2
good article.

I wonder if you could create a part two on running queries against databases with different collations using "Collate Database_Default" or other methods, tips etc.

A problem I am running into is this will not work on SQL7 so I must test server version first.

I have tried to avoid collation errors by clicking a check box CollationCompatible at LinkedServers/<ServerName>/Properties/ServerOptions but it does not seem to work.

Brian Lockwood
LockwoodTech Software

Brian Lockwood
ApexSQL - SQL Developer Essentials

Stand up for an Independent SQL Community - be Informed
Post #50496
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse