title: Character Set Mismatch Error in Oracle
body: <p>I have following query with me that I am trying to run:</p>
  
  <pre><code>SELECT Script from (
  
  SELECT 9 as ColOrder, ' INSERT INTO PROJ VALUES(' || ID || ',''' || Name || ''', ''' || Version || ''', ''ABCD'', sysdate , ''ABCD'', sysdate);' as Script FROM PROJ where Name like '%[Param.1]%'
  
  union
  
  SELECT 11 as ColOrder,' INSERT INTO PROJMOD VALUES(' || ID || ', ' || ProjID || ', ' || ModID || ', ' || ObjID || ', ''ABCD'', sysdate, ''ABCD'', sysdate);' as Script FROM PROJMOD where ProjID in ( select ID from PROJ where Name like '%[Param.1]%')
  
  ) x
  
  Order by ColOrder
  </code></pre>
  
  <p>But it gives me <code>ORA-12704: character set mismatch error.</code></p>
  
  <p>When I run both the select statement individually, it gives me proper output but when I am doing union of both select, it gives tme character set mismatch error.</p>
  
  <p>What can be wrong here?</p>