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
Average Rating