SQL & PL/SQL

1    NLS_NCHAR_CHARACTERSET    AL16UTF16

2    NLS_LANGUAGE    AMERICAN

3    NLS_TERRITORY    AMERICA

4    NLS_CURRENCY    $

5    NLS_ISO_CURRENCY    AMERICA

6    NLS_NUMERIC_CHARACTERS    .,

7    NLS_CHARACTERSET    EE8ISO8859P2

8    NLS_CALENDAR    GREGORIAN

9    NLS_DATE_FORMAT    DD-MON-RR

10    NLS_DATE_LANGUAGE    AMERICAN

11    NLS_SORT    BINARY

12    NLS_TIME_FORMAT    HH.MI.SSXFF AM

13    NLS_TIMESTAMP_FORMAT    DD-MON-RR HH.MI.SSXFF AM

14    NLS_TIME_TZ_FORMAT    HH.MI.SSXFF AM TZR

15    NLS_TIMESTAMP_TZ_FORMAT    DD-MON-RR HH.MI.SSXFF AM TZR

16    NLS_DUAL_CURRENCY    $

17    NLS_COMP    BINARY

18    NLS_LENGTH_SEMANTICS    BYTE

19    NLS_NCHAR_CONV_EXCP    FALSE

20    NLS_RDBMS_VERSION    10.2.0.5.0

I've an xml file in utf-8. I'd like to load it into db (table with xmltype and clob type column).

1. I can do this using clob column, but "special" signs are "broken" (implicit conversion)

2. I can't load xml file to xmltype column due encoding problem (LPX-00200: could not convert from encoding UTF-8 to ISO-8859-2)

Unfortunately, I can't change character setting - it's an old db in "production" mode.

Any help?