How can we help you today? How can we help you today?

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
DanSniderman
0

Comments

3 comments

Sort by
  • Sumanta
    @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?
    Sumanta
    0
  • Sumanta
    And really its not a warning, as the build breaks at Build step with that error.
    Sumanta
    0
  • Sumanta
    @Russell D
    @lfreijo
    any ideas? This is blocking a release now.
    Sumanta
    0

Add comment

Please sign in to leave a comment.