title: Character set mismatch oracle Error
body: <p>I have a SQL statement like this:</p>
  
  <pre><code>SELECT QUOTE_CREATION.*,
         CASE
            WHEN (SUBSTR (QUOTE_CREATION."PO_number", 1, 3)) = 'ARA'
            THEN
               'TE161938'
            WHEN (SUBSTR (QUOTE_CREATION."PO_number", 1, 3)) = 'HH-'
            THEN
               'TE161302'
            WHEN (SUBSTR (QUOTE_CREATION."PO_number", 1, 3)) = 'SMT'
            THEN
               'TE161101'
            WHEN (SUBSTR (QUOTE_CREATION."PO_number", 1, 3)) = 'AYP'
            THEN
               'TE108812'
            WHEN (SUBSTR (QUOTE_CREATION."PO_number", 1, 3)) = 'DKR'
            THEN
               'TE160895'
            ELSE
               QUOTE_CREATION."Created_By"
         END
            AS CORRECT_USER_ID
    FROM CCO.QUOTE_CREATION QUOTE_CREATION
  </code></pre>
  
  <p>But when i try to run the query I'm getting an error "Character set mismatch" at the " ELSE '' " part of the CASE expression. Can someone suggest where I'm doing it wrong?</p>
  
  <p>Thank you
  santhosha</p>