Insert these character ₤,€,ß,â,ä,ü,û,Ű in
Moderators: chulett, rschirm, roy
Please find the following details:DSguru2B wrote:What is your source? Is it a flat file or a database table? If a table then, what is the NLS character set in your source database? WHat happens when you write to a text file, do any of the characters show up?
Source :SQL server
NLS caracter set on sql server :ascii
Target :oracle
NLS caracter set on oracle UTF-8
Thanks &Regards
Srihari
-
- Premium Member
- Posts: 50
- Joined: Tue Jan 02, 2007 1:40 am
The key is in your NLS_LANG (and probably LC_CTYPE) environment variable setting. In order for the conversion to happen properly, Oracle needs to know the source character set is different from its native character set. Otherwise, everything is moved over unconverted and thus can become invalid in the process. To do this you need to override their values in your job by setting up User Defined Environment Variables in the Administrator and then including and overriding their value in the processing job.
It has been discussed and explained here a number of times, so not about to type it all up again. Searching the site for NLS_LANG and LC_CTYPE should turn up various conversations here, like this one as just one example.
It has been discussed and explained here a number of times, so not about to type it all up again. Searching the site for NLS_LANG and LC_CTYPE should turn up various conversations here, like this one as just one example.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers