title: Oracle character encoding
body: <p>I have an MVIEW on the DEV server as</p>
  
  <pre><code>CREATE MATERIALIZED VIEW MY_MVIEW
  AS
  SELECT  col1 AS "N° INVOICE" from TABLE
  </code></pre>
  
  <p>The MVIEW has been installed on PROD server and when i check for its query i have the characther <code>°</code> not recognized</p>
  
  <pre><code>SELECT query from user_mviews where mview_name = 'MY_MVIEW' ;
  
  QUERY
  ---------------------------------------
  SELECT  col1 AS "N? INVOICE" from TABLE
  </code></pre>
  
  <p>we use <code>Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production</code>
  for both environments .</p>
  
  <p>Any idea why this happened and how to correct it? or I need to rename my alias? </p>