Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Collation Problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-30 : 09:41:45
Demir writes "[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve collation conflict for column 4 in SELECT statement.

Hi,

When I make a query that does a union of two tables in different databases with different collations (one is the master db) I get the error above. Is there a way around without changing the collations.

Thanks
Demir"

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-07-30 : 10:36:59
Yes, you can explicitly force a collation conversion in the select statement with the COLLATE clause.

Jonathan Boott, MCDBA
{0}
Go to Top of Page
   

- Advertisement -