arabic character set

DSRajesh · Post by **DSRajesh** » Fri May 08, 2009 9:06 pm

Hi

Some of fields in source database sqlserver is having arabic characters which i need to set character set in datastage .

what would be the ANSI CODE PAGE i can use for tarabic and how can i change from default code page 1252.
What about client server map i need to use for arabic characters?
I also would like to know what will the parallel map i need to give

It would be helpful to me in getting resolving by any one this issue

thanks in advance

chulett · Post by **chulett** » Fri May 08, 2009 10:40 pm

Did you take a shot at an exact search for "arabic"? There's been quite a bit of conversation here on that general subject, would surprise me if none of it was helpful to you.

DSRajesh · Post by **DSRajesh** » Sat May 09, 2009 12:05 am

yes chullet,

i have search for the same and i found 2 topics but no required information peratining to above questions

can you please guide me here

DSRajesh · Post by **DSRajesh** » Sat May 09, 2009 3:21 am

My source is sqlserver and target is oracle
i am doing the below settings at source and target level for nls
source : nls_lang=utf8
target : nls_map=ms1256

while i try to execute the job it is giving fatal error : FATAL ERROR (APT_CharsetConverterRep::initConv()): MS1256 is not a valid codepage.

can anyone guide here about resolution

DSRajesh · Post by **DSRajesh** » Sat May 09, 2009 5:26 am

no one do response for this to answer my query .

moni · Post by **moni** » Sat May 09, 2009 5:55 am

Dear Rajesh,

Make the below settings and Try -

Parameter nls_lang=AMERICAN_AMERICA.AR8MSWIN1256
Default map for stages in the parameter NLS tab = windows-1256
Default Collation for stages = Project (OFF)
Stage level Make everything to job level.

Still its not working Please send me the following details.

1) Source DB NLS
2) Source stage name using to extract the data from DB(Eg: ODBC or DRS).
There is hell lot of settings to get the arbic charcters. But some settings will not work for some data. I have also struggled lot with the arabic data settings.

Please look into your private messages for my contact number.

DSRajesh · Post by **DSRajesh** » Sat May 09, 2009 6:54 am

DEAR Moni,

Parameter nls_lang =AMERICAN_AMERICA.AR8MSWIN1256

do i need to this setting in Windows registry/DB/Datastage?

Default map for stages in the parameter NLS tab = windows-1256

is windows -1256 is MS1256?

if it is the case ,i am getting error while using this map at target level.

Default Collation for stages = Project (OFF)

this is the same setting i have in my project settings

Stage level Make everything to job level.

These are my observations as per your sugessions.

regards
rajesh

chulett · Post by **chulett** » Sat May 09, 2009 9:05 am

DSRajesh wrote:no one do response for this to answer my query .

Sheesh - learn patience! For those of us in the western world, your later posts were well after midnight and into sleepy time, elsewhere you are firmly into the weekend. Not to mention the fact that whining for help doesn't get you help, usually quite the opposite. Being an all volunteer peer-to-peer site, people post when and how they can, not on your schedule. [/rant]

ray.wurlod · Post by **ray.wurlod** » Sun May 10, 2009 4:49 pm

Check (in Adminstrator client, logged as DataStage Administrator) whether the map MS1256 has, in fact, been loaded.

ray.wurlod · Post by **ray.wurlod** » Sun May 10, 2009 4:51 pm

To reinforce Craig's remarks, you may be in a part of the world where Friday and Saturday are not work days. But where he an I am, it is Saturday and Sunday that are not work days. And, curiously perhaps, I elect to have a life outside of IT.

chulett · Post by **chulett** » Sun May 10, 2009 6:22 pm

ray.wurlod wrote:And, curiously perhaps, I elect to have a life outside of IT.

What?

DSRajesh · Post by **DSRajesh** » Sun May 10, 2009 10:29 pm

Dear Ray,

MS1256 is got loaded in administrator but giving error if i take this as nls_lang while i execute the datastage job.

ray.wurlod · Post by **ray.wurlod** » Sun May 10, 2009 11:03 pm

Try loading/using the map ibm-1256 rather than MS-1256. They are the same, though the former is for parallel jobs and the latter for server jobs, which is where I think your error may have arisen.

If that doesn't work either, consult Appendix A of National Language Support Guide for more alternatives.

DSRajesh · Post by **DSRajesh** » Sun May 10, 2009 11:47 pm

Dear Ray,

I did not have the character set with IBM 1256 in Administrator in order to load that map for windows arabic.

regards
rd

DSRajesh · Post by **DSRajesh** » Sun May 10, 2009 11:54 pm

Dear Ray,

I am not able to find any parallel maps and locales in datastage administrator.but i am able to see server maps and locales.

what will be the possible reason for this