I am trying to load source table data which has special characters/spanish characters into target table through business objects data services.But BODS removes special characters and loads data to target table. Both source and target are oracle databases. I tried setting up code page in data store configurations but it doesnt seems to be working. Default code page is UTF-16.
Version : BODS 4.0
Source : Oracle 11i
Target : Oracle 11i
Can you please some one help me in resolving this issue as soon as possible.
I didn’t find the right solution from the internet.