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 |
christina_rules
Starting Member
23 Posts |
Posted - 2008-03-16 : 00:47:33
|
Hi,I've encountered an error while running my sql. "Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AS" in the equal to operation. I've check my collation settings in my master database and my own database and its the former. So, why am I still getting this error when my collation settings for both database is the same?It seems like I only get this error when I'm doing something like this:-Select * from table1, table2 where table1.PK = table2.FKPlease help. Any suggestions and feedback are welcomed. Thanks in advance. |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-16 : 11:41:23
|
check the columm collations.or do Select * from table1 join table2 on table1.PK collate Chinese_PRC_CI_AS = table2.FK collate Chinese_PRC_CI_AS _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
christina_rules
Starting Member
23 Posts |
Posted - 2008-03-20 : 01:04:14
|
hey, thanks :) |
|
|
|
|
|