title: UTL_FILE and character set
body: <p>I've been working on this thing for days and it's driving me crazy.<br>
  I have an oracle procedure that write a file using <code>UTL_FILE</code>.
  I used to store my values as NVARCHAR2 and write my file using <code>UTL_FILE.PUT_LINE_NCHAR</code> procedure, and it wrote file in (what notepad++ consider as) UTF8.<br>
  The file is then used by another program, the problem is that said program read it using WE8MSWIN1252, and I can't change that, since it's legacy code.<br>
  So I tried to use <code>UTL_FILE.PUT_LINE</code> procedure instead, but the file was still considered as UTF8. 
  I saw in oracle's documentation that <code>NVARCHAR2</code> used the national character set (mine is AL16UTF16), so I tried to use the <code>CONVERT</code> method like this:  </p>
  
  <pre><code>CONVERT(whatIWantToWrite, 'WE8MSWIN1252', 'AL16UTF16'))
  </code></pre>
  
  <p>and it raised the ORA-29298 Character set mismatch Exception.
  I don't get it, my <code>NLS_NCHAR_CHARACTERSET</code> is AL16UTF16 why can't I convert it to WE8MSWIN1252 ?<br>
  Is there another way to write a file using WE8MSWIN1252 ?</p>