I have a table in which our service provider insert UNICODE data but my oracle characterset is WE8ISO8859P1.
Now to get that data i used following function of oracle but it is displaying ???????
select CONVERT(message,'AL32UTF8','WE8ISO8859P1') from client_campaigns
one thing more message coulmn is of CLOB type.
I cant change characterset of my Database due to dataloss and second its in production and changes in characterset may lead to errors.
Now please guide how i can get this data as UNICODE?
Regards, imran
Strings inserted in a character (VARCHAR2 or CHAR or CLOB) column will always be converted to the database character set. This means that the inserted data is converted to WE8ISO8859P1 in your case. Since UNICODE is not a subset of WE8ISO8859P1, you will lose information. Some characters unavailable in your character set are transformed into ?
upon insert.
What should you do? There are a couple of options for new data:
I would go with option (1) or (3) if given the choice. Working with RAW disables a lot of features and adds complexity.
Obviously prior data will be impossible to restore with only the data available to the database: you will have to reimport old data in the new structure.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With