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.
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.ThanksDemir" |
|
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} |
|
|
|
|
|