Problems with special characters uploading data into oracle database

[Former Member]

Greetings

I have a problem uploading data into oracle tables from sybase datasource. The data that I want to upload is in Spanish, for example when I have a varchar field with the data 'Consultoría', in oracle table the data upload with interrogation symbols.

I have my source and target datastores configured as follows.

 

Any suggestion? Thank you for your time

[former_member187605 · Accepted solution]

Chack section 10 Locales and Multi-byte Functionality in the SAP Data Services Reference Guide for an exhaustive description of NLS settings.

As a summary, following settings are required:

• locales in the datastore definitions match the actual locale used in the associated databases
• the locale of the DS engine allows for source to target translation
• the character set in the target database supports storage of accented characters

[Former Member · Accepted solution]

Thank you Dirk. I had to change the NLS settings in my oracle database (target database)

[Former Member · Accepted solution]

Hi Victor,

Can you please let me know the exact changes the you did in the target database/data store to resolve this issue?

I have a similar issue when loading data to Oracle, i'm trying to load  value "PRODUITS SPÉCIALISÉ" from ECC using BODS and they are loaded as "PRODUITS SP¿CIALIS¿S" in Oracle.

Thanks,

Rohith

[Former Member]

Hi,

Whats the NLS_LANG , NLS_Territory, NLS_Charcaterset fof Oracle DB set to?

Arun