how to load Russian characters

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
karteek
Participant
Posts: 18
Joined: Tue Dec 06, 2011 8:50 am

how to load Russian characters

Post by karteek »

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
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

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
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Post Reply