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
Author
Message
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: Saturday, April 12, 2014 6:50 AM
Points: 1,040, Visits: 274
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/glarsen/collate_part2_1.asp

Gregory A. Larsen, MVP

Need SQL Server Examples check out my website at http://www.sqlserverexamples.com
Post #9014
Posted Monday, January 06, 2003 10:34 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, October 04, 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
http://www.lockwoodtech.com



Brian Lockwood
President
ApexSQL - SQL Developer Essentials

http://www.apexsql.com/blog

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

Add to briefcase

Permissions Expand / Collapse