DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
karteek
Participant



Joined: 06 Dec 2011
Posts: 18

Points: 407

Post Posted: Fri Feb 03, 2017 3:04 am Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
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



Group memberships:
Premium Members

Joined: 01 Mar 2007
Posts: 1715
Location: Troy, MI
Points: 9219

Post Posted: Thu Feb 16, 2017 7:11 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours