I am trying to load special characters (characters of a different language) into oracle table using oracle enterprise stage. target column is varchar .
I am able to load the record into table but the characters are changed to something else. Is there any setting I have to change so that oracle enterprise stage loads them without changing?
Using user defined update in enterprise stage.
Meaning you need to know the character set of your source and you need to know the characterset of your target and handle any mapping issues appropriately.
-craig
"You can never have too many knives" -- Logan Nine Fingers