special character

[solaik]

Hi,

Change datatype of this column to VarBinary in source/target stage then try.

Sai

[gsym]

Hi Sai,

Changed the datatype of this column to VarBinary, still the same problem...

[ArndW]

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.

[chulett]

Typically, the problem occurs when there is no conversion and data is simply moved over. As noted, correct NLS_LANG settings on each end are critical.

[gsym]

Hi ,

NLS is not installed with the data stage.

SELECT USERENV ('LANGUAGE') FROM DUAL;
Returns --> NLS_LANG=American_America.WE8ISO8859P15

SELECT * FROM NLS_DATABASE_PARAMETERS
the value for NLS_CHARACTERSET IS WE8IS08859P15

Thanks

[solaik]

Hi,

We faced similar problem in our project,by changing NLS settings to UTF8 or ISO***** solved this issue.

Thanks

[gsym]

Hi,

There is no conversion and data is simply moved over.

Thanks

[gsym]

Hi ,

Hi,

There is no conversion and data is simply moved over.
NLS is not installed, is it possible to move those characters without NLS?
Can we get those characters into the oracle by changing the NLS_CHARACTERSET?
Currently the the value for NLS_CHARACTERSET IS WE8IS08859P15.

Thanks

[gsym]

Hi,

Can anyone help me to solve this problem..

Thanks

[chulett]

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.

[gsym]

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

[chulett]

No. Perhaps you need to verify what encoding was actually used for your source file if 'UTF8' didn't help.