Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with importing a database with national (Polish) characters

Re: Problem with importing a database with national (Polish) characters

From: sybrandb <sybrandb_at_gmail.com>
Date: Thu, 21 Jun 2007 03:40:53 -0700
Message-ID: <1182422453.152702.274780@p77g2000hsh.googlegroups.com>


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 DBA
Received on Thu Jun 21 2007 - 05:40:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US