arabic data reading problem
Moderators: chulett, rschirm, roy
arabic data reading problem
Hi,
i am trying to read data from db2 v8 on AIX to oracle database using
db2 wire protocol, the tables contains Arabic data, the problem is the
Arabic data coming as ??????, the code page for the db2 is 1208.
i am using NLS =UTF8 in the ODBC stage.
any help is very appreciated.
(i searched the forum and i did not find anything helpful for me)
thanks in advance
i am trying to read data from db2 v8 on AIX to oracle database using
db2 wire protocol, the tables contains Arabic data, the problem is the
Arabic data coming as ??????, the code page for the db2 is 1208.
i am using NLS =UTF8 in the ODBC stage.
any help is very appreciated.
(i searched the forum and i did not find anything helpful for me)
thanks in advance
Try below links, may be useful!.
http://staff.in2.hr/denis/oracle/nls_data.html
http://www.microsoft.com/globaldev/nlsweb/default.mspx
http://staff.in2.hr/denis/oracle/nls_data.html
http://www.microsoft.com/globaldev/nlsweb/default.mspx
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
thanks for all valuable input,
sorry for replaying late, bcz our weekend is Thursday and Friday,
sia_999, i am seeing this ???? and unreadable characters using TOAD and sqlplus, i know we cannot see it from inside datastage.
any other solutions/ideas?
i moved one step that i can see correct data when loading it to sequential file, my problem now is to insert it correctly in the oracle target DB, i test all available NLS, but i get same result.
thanks for your replaying time.
sorry for replaying late, bcz our weekend is Thursday and Friday,
sia_999, i am seeing this ???? and unreadable characters using TOAD and sqlplus, i know we cannot see it from inside datastage.
any other solutions/ideas?
i moved one step that i can see correct data when loading it to sequential file, my problem now is to insert it correctly in the oracle target DB, i test all available NLS, but i get same result.
thanks for your replaying time.
you need to do two thingswaklook wrote:thanks for all valuable input,
sorry for replaying late, bcz our weekend is Thursday and Friday,
sia_999, i am seeing this ???? and unreadable characters using TOAD and sqlplus, i know we cannot see it from inside datastage.
any other solutions/ideas?
i moved one step that i can see correct data when loading it to sequential file, my problem now is to insert it correctly in the oracle target DB, i test all available NLS, but i get same result.
thanks for your replaying time.
first make sure that inserting some test data from toad and select the information, if it display correctly then the second step is to findout what is the code page of oracle is set, by issueing this command.
SELECT * FROM sys.V_$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';
after that source should be utf8 and the destination should be the oracle nls_characterset, I hope this will resolve your problem.
ilyas
you can try one more thing add the two lines to the dsenv file aswaklook wrote:Thanks again sia_999;
i did insert one row and it's fine.
the query output was 'AR8ISO8859P6',
i used 'IS08859-6' for the target and 'UTF8' for the source and no succeed.
NLS_LANG="AMERICAN_AMERICA.AR8ISO8859P6"
NLS_LANGUAGE="AMERICAN_AMERICA.AR8ISO8859P6"
then restart the etl service.
ilyas
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is no dsenv file on Windows-based DataStage servers. You can set up environment variables using Control Panel > System > Environment.
(Depending on which version of Windows, Environment may be a command button on one of the tabs in the System dialog.)
(Depending on which version of Windows, Environment may be a command button on one of the tabs in the System dialog.)
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.