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 |
satheesh
Posting Yak Master
152 Posts |
Posted - 2012-06-20 : 10:58:11
|
Dear all,I try to establish simple join between two table and i am getting select policy.policynumber ,filter.emailfrom policy inner join filter on filter.policynumber = policy.policynumber 'Msg 468, Level 16, State 9, Line 4Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation'How to fix this issue.Any help will be highly appreciated.ThanksRegards,SG |
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-20 : 11:18:16
|
col1 = col2 collate Latin1_General_CI_ASOr better change one of the columns so you have a consistent collation.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2012-06-21 : 02:25:38
|
It seems that the tables in join are having different collations. There are three solutions to solve this issue:1. If possible change the database collation.2. If possible change the server collation. 3. To allow specific queries to run despite the difference on collations, you need to modify those queries and include the COLLATE or COLLATE database_default clause when comparing string columns with different collations. Ref: http://www.sqlcoffee.com/Troubleshooting075.htm |
|
|
granuharmot
Starting Member
31 Posts |
Posted - 2014-09-23 : 05:21:08
|
unspammed |
|
|
|
|
|