Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with importing a database with national (Polish) characters
On Jun 21, 12:03 pm, "majster" <majs..._at_majster.com> wrote:
> 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.
The problem is
> import done in WE8ISO8859P1 character set and *AL16UTF16* **NCHAR** character set
> export server uses *WE8ISO8859P1* **NCHAR** character set (possible ncharset
> conversion)
Your Oracle 9i database has an incorrect NCHAR characterset (NON-UTF)
-- Sybrand Bakker Senior Oracle DBAReceived on Thu Jun 21 2007 - 05:40:53 CDT