Hi all,
we are running a BI 7.0 system. I'd like to extract data which contains chinese characters in NVARCHAR2 fields (Unicode-fields) from an Oracle 10.1 database via DB Connect.
The national character set (parameter NLS_NCHAR_CHARACTERSET), which count for these N*-fields (NCHAR, NVARCHAR2, NCLOB) is set to AL16UTF16.
I have created a DB Connect DataSource and accepted the proposed field mappings (NVARCHAR2 fields from the database are mapped to CHAR fields in the DataSource).
When I preview the data, I can only see inverted questions marks in those fields that contain chinese characters.
Any idea why the characters are garbled during extraction?
Thanks to any answers in advance!
Best regards,
Philipp