com.microsoft.sqlserver.jdbc.SQLServerException

Cannot resolve the collation conflict between "Danish_Norwegian_CI_AS" and "Latin1_General_CS_AS" in the equal to operation.

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1251

  • Cannot resolve the collation conflict between "Danish_Norwegian_CI_AS" and "Latin1_General_CS_AS" in the equal to operation.
  • via Google Groups by Fabrice Bellingard, 3 weeks ago
    Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "Latin1_General_CS_AS" in the equal to operation.
  • via Google Groups by Masimo, 3 weeks ago
    The data types xml and nvarchar are incompatible in the equal to operator.
  • Stack trace

    • com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "Danish_Norwegian_CI_AS" and "Latin1_General_CS_AS" in the equal to operation. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)[sqljdbc42.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)[sqljdbc42.jar:na]

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    3 times, 4 weeks ago
    120 times, 1 month ago
    Unknown user
    Once, 3 months ago
    Unknown user
    Once, 3 months ago
    Unknown user
    Once, 4 months ago
    82 more bugmates