What are the challenges you face when working across database platforms? Take the survey
Options

Collation Error

2018-01-16T20:09:18.5999633Z ##[warning]The error 'Cannot resolve the collation conflict between "Latin1_General_CI_AS_KS_WS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.' occurred when executing the following SQL:

I tried adding "IgnoreCollations" as a SQL Compare Options but still getting the error

Answers

  • Options
    SumantaSumanta Posts: 12 Bronze 1
    @DanSniderman
    How did you get past it...
    I am in the same boat.
    If I pass IgnoreCollations, I get:
    WARNING: The error 'Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.' occurred when executing the following SQL

    If I do NOT pass IgnoreCollations, I get:
    WARNING: The error 'Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.' occurred when executing the following SQL:

    Clearly I am missing some core concept here. Can anyone help?
  • Options
    SumantaSumanta Posts: 12 Bronze 1
    And really its not a warning, as the build breaks at Build step with that error.
  • Options
    SumantaSumanta Posts: 12 Bronze 1
    @Russell D
    @lfreijo
    any ideas? This is blocking a release now.
Sign In or Register to comment.