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
how to load Russian characters
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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
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.
Genius may have its limitations, but stupidity is not thus handicapped.