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
Share
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
More Stories
How to Print a Directory Structure Using PowerShell: Step-by-Step Guide
If you need to print out the directory structure and list the files within, this PowerShell script will help you...
Windows God Mode… What!?!
Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.
How To Test A SQL Server Connection
There is an easy way to test your SQL Server connection when running Windows without any special software. I found...
4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....
Get The Size & Record Count Of All Tables In A SQL Server Database
Use the SQL query below to display the size and record count of all tables in an SQL Server database....
How To Get AS400/iSeries Job Queue Information Using SQL
I received a request the other day about the JD Edwards EnterpriseOne job queues and what the maximum number of...
Average Rating