Collation error in 'build' step does not get ignored by 'IgnoreCollation'

• 
  Hi Sumanta
  
  Thank you for your forum post.
  
  The IgnoreCollations option simply ignores collations on character data type columns when comparing and deploying databases.
  
  If this was comparing and deploying successfully prior to your unrelated change, are you able to reply with information regarding this change?
  
  What are the details of the SQL query being executed that causes this message:
  

  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:
  

  Many Thanks
  Eddie

  Eddie D October 01, 2018 09:58

  - 0 +
• 
  Thank you for your reply @Eddie D .
  Not sure what kind of details are you looking for. The change was a migration script that queries a value from a different DB and based on the result deletes some rows in a table. The .patch file is clean (only shows dependency on the recently upgraded tool, and the table that the script deletes rows from).
  Does that answer your question?

  Sumanta October 01, 2018 17:05

  - 0 +
• 
  Hi Sumanta
  Thank you for your reply.
  
  I suspect that you have mixed collations for a column is table between the source and the target.  Are you able to identify the T-SQL code that is causing this message to occur?
  
  The SQL code after the the message:
  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:
  
  Many Thanks
  Eddie

  Eddie D October 04, 2018 15:24

  - 0 +

Add comment

Please sign in to leave a comment.