Skip to main content
Skip table of contents

How to solve "Cannot resolve the collation conflict between X and Y" error

Steps to reproduce

When executing a query you see an error that looks like this:

Cannot resolve the collation conflict between "SQL_Latin1_X" and "SQL_Latin1_Y" in the concat operation

When you execute the same query directly on your database, it works fine.


The collation of your external DB and your own DB do not match.


If you are using a MSSQL database, Atlassian has an article on how to fix this:

You could also add COLLATE statements to your query, as described here:

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.