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
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 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
Roy R.
Time is money but when you don't have money time is all you can afford.