Code Fix: A database collation error occurs on a form at runtime
KB003532
PRODUCT
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”.
Resolution
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 |
- Ensure you have the correct K2 version and/or Cumulative Update installed. See KB001893 to see what Fix Pack level you have installed.
- Download the latest Fix Pack using the links in the table above for the version you require.
- Install the Fix Pack to apply the fix.
- It is recommended to refresh the browser cache.