SQL Server Error: Cannot resolve the collation conflict between "Latin1_General_CI_AS_WS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation

Read Time:36 Sec

I received the following error when trying to join an EnterpriseOne 9.1 table with an EnterpriseOne 8.12 table that was copied to the SQL Server from an iSeries using R98403:

Cannot resolve the collation conflict between “Latin1_General_CI_AS_WS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation

The way I resolved the issue was to specify the field’s collation by placing “COLLATE DATABASE_DEFAULT” after the field name:

 
SELECT a.FRDTAI,a.FRCDEC AS a_FRCDEC, b.FRCDEC AS b_FRCDEC 
FROM JDE910.DD910.F9210 a 
INNER JOIN DD812.PRODDTA.F9210 b ON 	
(a.FRDTAI COLLATE DATABASE_DEFAULT = b.FRDTAI COLLATE DATABASE_DEFAULT) 
WHERE a.FRCDEC COLLATE DATABASE_DEFAULT  b.FRCDEC COLLATE DATABASE_DEFAULT 

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA  What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.
Happy
Happy
1
Sad
Sad
0
Excited
Excited
0
Sleepy
Sleepy
0
Angry
Angry
1
Surprise
Surprise
0

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Previous post Unable to Delete iSeries Physical File
Next post How To Compare Field Values Between Tables