< class="prominent-subhead ">

Code Fix: A database collation error occurs on a form at runtime


Issue Description

When you use a SQL database with a different collation on a view that uses a SmartObject from the K2 database, and create a join in the view on 2 text values, at runtime an error occurs on the form.

Error Message

The following error occurs: “Cannot resolve the collation conflict between [K2 DB collation name] and [different DB collation name] in the equal to operation”.


The fix is available in the following K2 versions:

K2 4.7 December 2019 Cumulative Update K2 Five (5.0) December 2019 Cumulative Update K2 Five (5.1) November 2018 Cumulative Update K2 Five (5.2) May 2019 Cumulative Update K2 Five (5.3) April 2020 Cumulative Update
X X X X Fix Pack 5
  1. Ensure you have the correct K2 version and/or Cumulative Update installed. See KB001893 to see what Fix Pack level you have installed.
  2. Download the latest Fix Pack using the links in the table above for the version you require.
  3. Install the Fix Pack to apply the fix.
  4. It is recommended to refresh the browser cache.