Originally posted by: Ole Haavard Haug-Larsen
Hi.
I'm having problems with Norwegian charset (Æ,Ø,Å) when transforming from UTF-8 to Oracle database.
WTX is installed at a Linux server with charset UTF-8 and the input-file is a XML containing Norwegian characters. When I map to new file at the Linux, there are no problem. BUT when I transform to a Oracle Database, the Norwegian characters are 'corrupt'. The content of the file is mapped into a CLOB-defined field in the DB-table.
I have tried to set Data language in the type-tree (have tried different values), but the Æ, Ø and Å are stil wrong when storing to DB.
The DB-environment have also been controlled:
|
NLS_RDBMS_VERSION
|
12.1.0.2.0
|
|
NLS_NCHAR_CONV_EXCP
|
FALSE
|
|
NLS_LENGTH_SEMANTICS
|
BYTE
|
|
NLS_COMP
|
BINARY
|
|
NLS_DUAL_CURRENCY
|
$
|
|
NLS_TIMESTAMP_TZ_FORMAT
|
DD-MON-RR HH.MI.SSXFF AM TZR
|
|
NLS_TIME_TZ_FORMAT
|
HH.MI.SSXFF AM TZR
|
|
NLS_TIMESTAMP_FORMAT
|
DD-MON-RR HH.MI.SSXFF AM
|
|
NLS_TIME_FORMAT
|
HH.MI.SSXFF AM
|
|
NLS_SORT
|
BINARY
|
|
NLS_DATE_LANGUAGE
|
AMERICAN
|
|
NLS_DATE_FORMAT
|
DD-MON-RR
|
|
NLS_CALENDAR
|
GREGORIAN
|
|
NLS_NUMERIC_CHARACTERS
|
.,
|
|
NLS_NCHAR_CHARACTERSET
|
AL16UTF16
|
|
NLS_CHARACTERSET
|
AL32UTF8
|
|
NLS_ISO_CURRENCY
|
AMERICA
|
|
NLS_CURRENCY
|
$
|
|
NLS_TERRITORY
|
AMERICA
|
|
NLS_LANGUAGE
|
AMERICAN
|
Any tips and suggestions??
#IBMSterlingTransformationExtender#DataExchange#IBM-Websphere-Transformation-Extender