DSXchange

Posted: **Wed Nov 30, 2011 7:40 pm**

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,

Posted: **Wed Nov 30, 2011 7:45 pm**

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.

Posted: **Wed Nov 30, 2011 8:53 pm**

What is the characterset of the source database?

Posted: **Wed Nov 30, 2011 10:13 pm**

Hi Craig
Character set of the source database

NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_LANGUAGE : AMERICAN
NLS_TERRITORY : AMERICA

Posted: **Wed Nov 30, 2011 10:23 pm**

Hi there
I can see several maps in DS Aministrator, can u please suggest one which is tested in time when such problem pops up

Thanks for your prompt reply

Posted: **Thu Dec 01, 2011 7:28 am**

What happens when you use the source database characterset in your job?

Posted: **Tue Dec 06, 2011 9:58 pm**

chulett wrote:What happens when you use the source database characterset in your job?

The Problem was solved...
Thanks Everyone

Posted: **Sun Sep 09, 2012 1:39 am**

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

Posted: **Sun Sep 09, 2012 1:44 am**

I think it's reasonably safe to infer, because Craig's post was quoted, that Craig's suggestion was the resolution.

DSXchange

UTF-8

UTF-8

characterset of source databae