Euro Character lost on export/import

Hi.

An Euro symbol character in varchar2 fields gets lost on export and import beteen different databases.

Source: Oracle 8i, NLS_CHARACTERSET WE8ISO8859P1 Target: Oracle 9i, NLS_CHARACTERSET AL32UTF8 (Unicode)

We're running a Java-based web app with the 8iDB and migrating to 9i. There are definitely fields with the Euro sym in the 8iDB. They are displayed in the web app. After migration, the Euro sym has changed to a question mark.

I would simply like to know if I'm right with the following:

WE8ISO8859P1 char set doesn't support the Euro (WE8ISO8859P15 does), and Oracle "invents" its own code to represent the Euro sym. That's the reason the 8i app can display it. On import, all texts are converted from WE8ISO8859P1 to AL32UTF8. Since Euro is not in WE8ISO8859P1, there is no mapping for the oracle-invented Euro char code, as no conversion.

Conclusion: There is nothing we can do as to live with it. If we had chosen WE8ISO8859P15 for the 8iDB in the beginning, we wouldn't have the trouble today.

Right?

Looking forward to your comments,

Tosta.

P.S. The other problems migrating to unicode, namely the length-semantics problem, have been solved already, thanks. Received on Tue Aug 10 2004 - 07:29:05 CDT