DSXchange

Hi All,

i am facing issue with Russian characters

source file contains Russian characters when i am loading in teradata database it is populating with different characters.


target field : COL1 VARCHAR(240) CHARACTER SET UNICODE NOT CASESPECIFIC,


i tried below option :

1. in schema file i placed

a. charset='ISO8859-1'
b. charset='UTF-8'

NLS_MAP : UTF-8,ibm-866_P100-1995



example :

source data : Й й
data set it is loaded as : ц╙ц┼ ,
database it loaded as : ъ ╩


Please help me which character set,nls_map i need to use.


Thanks,
Karteek

Seems its already late but if its solved please post the answer for future searchers.

Are you getting any warning? does your NLS map matches the one in teradata and the source?

PS:
Unicode is not UTF-8.
8859-P1 is US ASCII