Problem reading US7ASCII character set from an Oracle RDB7
Posted: Fri Dec 18, 2009 10:03 am
Hi,
This is urgent!![Confused :?](./images/smilies/icon_confused.gif)
Givens:
- Oracle RDB 7 database, holds US7ASCII character set (Contains Arabic data)
- We need to migrate this data to Oracle 10G database using datastage ETL.
- Oracle SQLPlus from the client on Windows reads this data as rubbish one, and datastage do the same thing each time i try to read the Arabic fields it rends rubbish data, but of course it can read the English one correctly.
Facts:
Although i knew that DataSatge don't require NLS conversion to read 7bit data, but it still could not read it...
I have tried lots of nls conversions with no use!.
The only case that we can read Arabic correctly from this database, is that when we use a PLSQL application created previously to convert this 7bit (US7ASCII) characters to 8bit (US8ASCII) and view it from an oracle form application.
So we have stuck in our migration project, as we can not read arabic correctly from the DataStage ETL, and of course we can not load it that way in the destination database.
Q1: is there a way that we could plug in this PLSQL application to the datastage server, in order to do the same thing and interpret those arabic characters and read them correctly into our ETL and then load it right?
Q2: is there a way that we could read the US7ASCII characters directly from datastage using any type of NLS customization or handling?
Q3: could this problem be related to the nls_lang setting on the Oracle Client installed on the Datastage server itslef?
Your help would be very highly appreciated.
Thank you
![Confused :?](./images/smilies/icon_confused.gif)
This is urgent!
![Confused :?](./images/smilies/icon_confused.gif)
Givens:
- Oracle RDB 7 database, holds US7ASCII character set (Contains Arabic data)
- We need to migrate this data to Oracle 10G database using datastage ETL.
- Oracle SQLPlus from the client on Windows reads this data as rubbish one, and datastage do the same thing each time i try to read the Arabic fields it rends rubbish data, but of course it can read the English one correctly.
Facts:
Although i knew that DataSatge don't require NLS conversion to read 7bit data, but it still could not read it...
I have tried lots of nls conversions with no use!.
The only case that we can read Arabic correctly from this database, is that when we use a PLSQL application created previously to convert this 7bit (US7ASCII) characters to 8bit (US8ASCII) and view it from an oracle form application.
So we have stuck in our migration project, as we can not read arabic correctly from the DataStage ETL, and of course we can not load it that way in the destination database.
Q1: is there a way that we could plug in this PLSQL application to the datastage server, in order to do the same thing and interpret those arabic characters and read them correctly into our ETL and then load it right?
Q2: is there a way that we could read the US7ASCII characters directly from datastage using any type of NLS customization or handling?
Q3: could this problem be related to the nls_lang setting on the Oracle Client installed on the Datastage server itslef?
Your help would be very highly appreciated.
Thank you
![Smile :)](./images/smilies/icon_smile.gif)
![Confused :?](./images/smilies/icon_confused.gif)