title: how we can select two columns having different collation
body: <p>I have an SQL query like</p>
  
  <pre><code>SELECT Col1, Col2 FROM Table1
  UNION ALL 
  SELECT Col1, Col2 FROM Table2
  </code></pre>
  
  <p>where <code>col1</code> and <code>col2</code> are strings and using collations.</p>
  
  <p>When I run the query it shows the error: </p>
  
  <ol>
  <li>Cannot resolve collation conflict for column 1 in statement.</li>
  <li>Cannot resolve collation conflict for column 2 in statement.</li>
  </ol>
  
  <p>Any one please help.</p>