Hi everybody,
We have a table which has russian characters.
We are trying to see the data through view data from oracle stage it's giving "??????" symbols.
We have tried to use a $NLS_LANG env variable & passed "AMERICAN_AMERICA.AL32UTF8" parameter value to it.
Still it is not working. Please suggest what can be done
Regards,
UTF-8
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
The AMERICAN_AMERICA.AL32UTF8 character map clearly does not handle Cyrillic characters, because "written American" (if I may use that description) does not use them.
You need to specify a map that can handle Russian characters. Every map includes ASCII characters, so all you need to do is to find the correct map name.
You may need to set NLS_LANG for Oracle but, in addition, set map name for DataStage, at project or job level.
The AMERICAN_AMERICA.AL32UTF8 character map clearly does not handle Cyrillic characters, because "written American" (if I may use that description) does not use them.
You need to specify a map that can handle Russian characters. Every map includes ASCII characters, so all you need to do is to find the correct map name.
You may need to set NLS_LANG for Oracle but, in addition, set map name for DataStage, at project or job level.
Last edited by ray.wurlod on Wed Nov 30, 2011 9:55 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
characterset of source databae
Hi Craig
Character set of the source database
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_LANGUAGE : AMERICAN
NLS_TERRITORY : AMERICA
Character set of the source database
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_LANGUAGE : AMERICAN
NLS_TERRITORY : AMERICA
Any one knows the solution ?!
(even a year later as it may be)
I think it is not ok to open a topic and then simply say its resolved!
How about something regarding the solution
(even a year later as it may be)
I think it is not ok to open a topic and then simply say its resolved!
How about something regarding the solution
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: