special character
Moderators: chulett, rschirm, roy
Re: special character
Hi,
Change datatype of this column to VarBinary in source/target stage then try.
Sai
Change datatype of this column to VarBinary in source/target stage then try.
Sai
Stay with VarChar, these characters are not really `special'. NLS is only needed if you need to manipulate non-latin characters, not if you only wish to move them around. What are your Oracle character set settings, it is possible that the conversion is happening there.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
You don't need NLS. Proper setting of the NLS_LANG environment variable in the job's session should solve your problem. Search for NLS_LANG, LC_CTYPE and Oracle to find several other posts discussing both the problem and the solutions people have found.
You'll find mention of creating a user defined variable for $NLS_LANG via the Administrator and then overriding the default value in the job in question.
You'll find mention of creating a user defined variable for $NLS_LANG via the Administrator and then overriding the default value in the job in question.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi ,
Defined the User Defined Environment Variable for NLS_LANG and for LC_CTYPE in the Administrator for the project. Set the values to $ENV . Added the parameters in the jobParameters and override the
default values to AMERICAN_AMERICA.UTF8 and C.utf8.
Still the same problem...
dsenv template is
#LANG="<langdef>";export LANG
#LC_ALL="<langdef>";export LC_ALL
#LC_CTYPE="<langdef>";export LC_CTYPE
#LC_COLLATE="<langdef>";export LC_COLLATE
#LC_MONETARY="<langdef>";export LC_MONETARY
#LC_NUMERIC="<langdef>";export LC_NUMERIC
#LC_TIME="<langdef>";export LC_TIME
#LC_MESSAGES="<langdef>"; export LC_MESSAGES
Do i need to change this dsenv template too ?
Thanks
Defined the User Defined Environment Variable for NLS_LANG and for LC_CTYPE in the Administrator for the project. Set the values to $ENV . Added the parameters in the jobParameters and override the
default values to AMERICAN_AMERICA.UTF8 and C.utf8.
Still the same problem...
dsenv template is
#LANG="<langdef>";export LANG
#LC_ALL="<langdef>";export LC_ALL
#LC_CTYPE="<langdef>";export LC_CTYPE
#LC_COLLATE="<langdef>";export LC_COLLATE
#LC_MONETARY="<langdef>";export LC_MONETARY
#LC_NUMERIC="<langdef>";export LC_NUMERIC
#LC_TIME="<langdef>";export LC_TIME
#LC_MESSAGES="<langdef>"; export LC_MESSAGES
Do i need to change this dsenv template too ?
Thanks