title: SQL COLLATION can not resolve
body: <p>On our development server, we have a database server with collation: COLLATE <code>SQL_Latin1_General_CP1_CI_AS</code>.</p>
  
  <p>After deploying our solution on a server and that database server has collation: COLLATE <code>SQL_Latin1_General_CI_AS</code></p>
  
  <p>That means if we have a query:</p>
  
  <pre><code>SELECT ('text' + 'abc') AS 'result'
  </code></pre>
  
  <p>I got this problem: </p>
  
  <p>Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict.</p>
  
  <p>So I tried this: <code>ALTER DATABASE [mydb] COLLATE SQL_Latin1_General_CP1_CI_AS</code></p>
  
  <p>then I check the property of the myDB, the collate is changed to: <code>SQL_Latin1_General_CI_CS_AS</code> but I still get the same error.</p>
  
  <p>Other topics suggest to reinstall the database. But that is not the case we will lose all of the data.</p>
  
  <p>Any suggestion is very appreciated!</p>
  
  <p>Thanks in advance.</p>