Code Fix: A SQL error occurs when the K2 database and SQL server collation differs
KB002188
PRODUCT
Issue Description
When executing a joined SmartObject when the K2 database Collation differs from the SQL Server Collation, a SQL error returns.
Error Message
The error states: “Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation”.
Resolution
- Ensure you have K2 Five RTM installed.
- Get the K2 Five RTM FP7 from Regional Support.
- Install the K2 Five RTM FP7 to apply the fix.