title: How to convert characterset of column in Oracle
body: <p>I have a table in which our service provider insert UNICODE data but my oracle characterset is WE8ISO8859P1.</p>
  
  <p>Now to get that data i used following function of oracle but it is displaying ???????</p>
  
  <p>select CONVERT(message,'AL32UTF8','WE8ISO8859P1')  from client_campaigns</p>
  
  <p>one thing more message coulmn is of CLOB type.</p>
  
  <p>I cant change characterset of my Database due to dataloss and second its in production and changes in characterset may lead to errors.</p>
  
  <p>Now please guide how i can get this data as UNICODE?</p>
  
  <p>Regards,
  imran  </p>