Folks,
I am trying to insert data from access to a database table. I am calling this Access file using ODBC stage. All goes fine expect with one column which contains Arabic data. This is been displayed as junk data.
When I try to laod the same from a flat file i am able to do by changing my NLS to 'Unicode'.(for this I am getting the text itself in Unicode)
I tried with all the avialbale NLS for odbc stage. But invain.
Plzz one help me out.
Thanks in advance
rajesh
Display of Arabic Characters
Moderators: chulett, rschirm, roy
This too cannt be done directly.
I need to MANUALLY export data from access to Excel and from Excel I need to re-export tht to text file. Then I can use this file in order to get the Arabic data. But this is a huge process as i do have lots of Access files and in each i have more than 1 lac of records. And excel at a time accepts only 65K reocrds. For this i need to split my file. This consumes hell of time.
i am trying to load directly from Access.
I also tried laoding into a text file first and then into the database. Even this is not working. In this process even the sequential file is not capturing Arabic Data.
thanks,
rajesh
I need to MANUALLY export data from access to Excel and from Excel I need to re-export tht to text file. Then I can use this file in order to get the Arabic data. But this is a huge process as i do have lots of Access files and in each i have more than 1 lac of records. And excel at a time accepts only 65K reocrds. For this i need to split my file. This consumes hell of time.
i am trying to load directly from Access.
I also tried laoding into a text file first and then into the database. Even this is not working. In this process even the sequential file is not capturing Arabic Data.
thanks,
rajesh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That suggests one of two things - either it's not Arabic, or you do not know how it is encoded. You definitely do need to know that. Then, once the encoding is known, you will probably need to build that NLS map for DataStage (done from the NLS button in the Administrator client) and use it either for reading the text file, or for reading directly from Access using ODBC.
Be aware that sorting Arabic characters can take up to five passes through the data - it may make your DataStage processing seem very slow, but it's just how things are. Avoid sorting these data as much as possible.
Be aware that sorting Arabic characters can take up to five passes through the data - it may make your DataStage processing seem very slow, but it's just how things are. Avoid sorting these data as much as possible.
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.
Re: Display of Arabic Characters
Rajesh,
Check your Datastage Server Installation NLS setting and Microsoft access deafult NLS setting.
Both should be same inorder for you to have proper arabic display.
Best Regards
Sunoj Thomas
Check your Datastage Server Installation NLS setting and Microsoft access deafult NLS setting.
Both should be same inorder for you to have proper arabic display.
Best Regards
Sunoj Thomas
raj_konig wrote:Folks,
I am trying to insert data from access to a database table. I am calling this Access file using ODBC stage. All goes fine expect with one column which contains Arabic data. This is been displayed as junk data.
When I try to laod the same from a flat file i am able to do by changing my NLS to 'Unicode'.(for this I am getting the text itself in Unicode)
I tried with all the avialbale NLS for odbc stage. But invain.
Plzz one help me out.
Thanks in advance
rajesh
Sunoj Thomas
ARAB NATIONAL BANK-HEAD OFFICE
Annex Building IInd Floor(BSD)
P.O BOX 56921
RIYADH -11564
Mob:00966-502573856
Office:00966-1-4029000X4294
ARAB NATIONAL BANK-HEAD OFFICE
Annex Building IInd Floor(BSD)
P.O BOX 56921
RIYADH -11564
Mob:00966-502573856
Office:00966-1-4029000X4294
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: