title: Charset mismatch when querying from db link
body: <p>I'm querying from a 10g database using a dblink to an 8i database.</p>
  
  <pre><code>select col1, col2 ... from table@my_dblink_to_8i
  </code></pre>
  
  <p>8i charset is <code>IW8ISO8859P8</code></p>
  
  <p>10g charset is <code>WE8MSWIN1252</code></p>
  
  <p>the data is coming out as gibrish. I've tried all of variations I can think of </p>
  
  <pre><code>to_char(col1)
  cast(col1 as nchar(4))
  cast(col1 as nvarchar2(4))
  cast(col1 as char(4))
  cast(col1 as varchar2(4))
  convert(col1, 'WE8MSWIN1252', 'IW8ISO8859P8')
  convert(convert(col1,'UTF8','IW8ISO8859P8'),'WE8MSWIN1252','UTF8')
  </code></pre>
  
  <p>all returning with either gibrish or </p>
  
  <pre><code>ORA-12704: character set mismatch
  ORA-02063: preceding line from OTHERDB
  </code></pre>
  
  <p>any suggestions ?</p>
  
  <p>Is there an intermediate charset I can convert to ? </p>