Handling of accents, ñ, Ö, ü ... and more.

system · March 17, 2011, 8:10pm

Hi everyone,

I have source tables with accents, ñ, Ö, ü, ä, Ä, é, è, ï, ô, ê, Ø, ã, â, ç, õ, ô, ö, á, ú, ó, í.

When I pass the data to a destination table does not recognize any of these characters. How I can do to take them as is?

Thanks a lot for your help.

fra_03 (BOB member since 2011-03-16)

system · March 17, 2011, 8:59pm

Another point is that this happens because the source tables are SAP and target tables are Oracle.

Could it be that Oracle is missing something?

Total Thanks!

fra_03 (BOB member since 2011-03-16)

system · March 18, 2011, 1:11am

problem could be because of incorrect NLS_LANG setting for the oracle client on the Job server machine

depending on territory and language set the NLS_LANG correctly and restart the DS Service and run the job

manoj_d (BOB member since 2009-01-02)

system · March 18, 2011, 9:51am

An Oracle step-by-step guide.

Werner Daehn (BOB member since 2004-12-17)

system · March 18, 2011, 6:12pm

I changed the settings DSConfig, Regedit, Datastore … What could be missing?.

Attached image of the changes I made.

Thanks so much for all the contributions.

fra_03 (BOB member since 2011-03-16)

system · March 18, 2011, 6:16pm

set the datastore code page and server codepage to cp1252 and see if that works

manoj_d (BOB member since 2009-01-02)

system · March 18, 2011, 6:57pm

Wonderful!, That was!.

I’m Happy, Thank you so much!.

This forum is best.

fra_03 (BOB member since 2011-03-16)

system · October 5, 2012, 6:21pm

had the same exact problem and it worked for me too, thank you

alespissoto (BOB member since 2012-10-05)