Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Converting from WE8ISO8859P15 to WE8ISO8859P1

547920Sep 26 2007 — edited Sep 26 2007

Hi,

We have a database that was created with WE8ISO8859P15 instead of WE8ISO8859P1. The data (including charachters in WE8ISO8859P1 and not in WE8ISO8859P15 ) that is being loaded in the database is being loaded (via external tables) with the correct ascii code, for example the accent ´ is saved as 180, however becuase of the database characterset its is then displayed with the character mapped in WE8ISO8859P15 in this case Ž.

As far as I can tell from reading the docs, if I try to convert the Database back to WE8ISO8859P1 (which in itself may require oracle support) the unconvertable characters such as the above will be converted to the ¿ (ascii 191), I tried this via export import and that was certainly the case.

Is there a way I can convert the DB backto WE8ISO8859P1, convert anything... ie leaving the code points exactly as they are... this should provide me with the correct result.

Any suggestions would be appreciated

James

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 24 2007

Added on Sep 26 2007

#database-key-features, #globalization-support

3 comments

8,431 views