Strange Characters

[#1]

We are having issues on the BODI extracts having strange characters. We get data from the source system (SAP R/3 table) and put all the data in the SAP download file. During this process, all the unique characters from S1P were consistently and successfully placed in the file. The SAP download file will be used to load an staging Oracle table. The problem now occurs here as the unique characters were not transferred as it is. The BODI version we used is 11.7.3.

BODI Application Server:

- NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P15

-Code Page: 1252

ORACLE Database

- NLS LANG: AMERICAN_AMERICA.UTF8

- Version: 8.1.7

[RyanChamplin]

Is the column in the Oracle database you're loading this data into defined as a varchar2 or nvarchar2?

There are two different character encoding settings in Oracle that control which encoding is used for varchar2 vs. nvarchar2.

I'm assuming this was obvious but thought I would double check. The DBA can check the NLS_CHARACTERSET vs. the NLS_NCHAR_CHARACTERSET which should align with the column type you're using.

Ryan