arabic character set
Moderators: chulett, rschirm, roy
arabic character set
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
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
RD
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
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
RD
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.
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.
Nothing is Impossible..!!
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
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
RD
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]DSRajesh wrote:no one do response for this to answer my query .
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
If that doesn't work either, consult Appendix A of National Language Support Guide for more alternatives.
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.