title: Oracle to SQL character set conversion
body: <p>I have an Oracle DB that I'm accessing through a linked server in SQL Server using OPENQUERY. There are some Portuguese accented characters stored in the Oracle DB that when I view them in the query results have incorrect characters placed in front of the accented ones. I've tried multiple versions of CASTing and CONVERTing in both the Oracle query and the SQL results and I've played with the collation setting on the linked server as well. Nothing I've tried has worked. </p>
  
  <p>The column in the Oracle DB is defined as NVARCHAR2(240), and the NLS_NCHAR_CHARACTERSET is AL16UTF16.</p>
  
  <p>I'm not sure what other info would be helpful, if I missed something let me know.</p>
  
  <p>Thanks in advance for any help!</p>