Problem with importing a database with national (Polish) characters

From: majster <majster_at_majster.com>
Date: Thu, 21 Jun 2007 12:03:35 +0200
Message-ID: <f5dhdk$14sq$1@news2.ipartners.pl>

Hi,

We have problems in importing an Oracle 8 database into Oracle 9 server. Polish national characters do not transfer correctly.

The import comes up with the following message:

---

import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)

---

(The original message in Polish is:
import wykonany dla zestawu znakow WE8ISO8859P1 i zestawu znakow AL16UTF16 NCHAR
serwer eksportu uzywa zestawu znakow WE8ISO8859P1 NCHAR (mozliwa konwersja zesta
wu znakow)

The target database uses WE8ISO8859P1 character set and AL16UTF16 NCHAR character set, and the nls_lang was set to POLISH_POLAND.WE8ISO8859P1, still the Polish characters are not transferred correctly, except "ó", whose ASCII code is below 256.

Did anyone meet such a problem?

Regards,
D.W. Received on Thu Jun 21 2007 - 05:03:35 CDT