Collation Error

DanSnidermanDanSniderman Posts: 2 New member
in DLM Automation
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
· Share on Twitter

Answers

  • 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?
    · Share on Twitter
  • SumantaSumanta Posts: 12 Bronze 1
    And really its not a warning, as the build breaks at Build step with that error.
    · Share on Twitter
  • SumantaSumanta Posts: 12 Bronze 1
    @Russell D
    @lfreijo
    any ideas? This is blocking a release now.
    · Share on Twitter
Sign In or Register to comment.