Polish Character Issue in Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 6
- Joined: Mon Nov 09, 2009 3:14 am
- Location: Mumbai
I had tried numerous NLS packages
@ray.wurlod
I had tried numerous NLS packages like ISO-8859-1 ( proj default),8859-2,8859-12,UTF-8,IBM 01147,IBM 918,8859-1:1987 but i could not resolve the issue .
I had done these changes in the NLS tab of the job properties wherin i have changed the Default map for Stages section
Could you please suggest an appropriate pack for the same
I had tried numerous NLS packages like ISO-8859-1 ( proj default),8859-2,8859-12,UTF-8,IBM 01147,IBM 918,8859-1:1987 but i could not resolve the issue .
I had done these changes in the NLS tab of the job properties wherin i have changed the Default map for Stages section
Could you please suggest an appropriate pack for the same
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 6
- Joined: Mon Nov 09, 2009 3:14 am
- Location: Mumbai
@Sreen
1. I did not get your question ?
Are you able to see the polish characters when you open in the unix box ?
I have used a csv and db stage in the existing job having the NLS pack of 8859-1 (proj default).
Then created another job to read the csv using the UTF-8 pack and i was able to see the data correctly. This means datastage pack is converting the data into an intermediate format and while reading it agains converts into the original form. This is within datastage but in DB is still showing incorrect value.
2. The code of db is 1208 which supports the polish character. I manually updated the records in DB and was able to view them correctly. Hence there is no issue in DB.
The problem i am facing is while loading the data from the queue to DB , the translation is done by Datastage and hence the characters are not loaded properly in DB.
Let me know if you require some further inputs
1. I did not get your question ?
Are you able to see the polish characters when you open in the unix box ?
I have used a csv and db stage in the existing job having the NLS pack of 8859-1 (proj default).
Then created another job to read the csv using the UTF-8 pack and i was able to see the data correctly. This means datastage pack is converting the data into an intermediate format and while reading it agains converts into the original form. This is within datastage but in DB is still showing incorrect value.
2. The code of db is 1208 which supports the polish character. I manually updated the records in DB and was able to view them correctly. Hence there is no issue in DB.
The problem i am facing is while loading the data from the queue to DB , the translation is done by Datastage and hence the characters are not loaded properly in DB.
Let me know if you require some further inputs
-
- Participant
- Posts: 16
- Joined: Wed Apr 30, 2014 1:27 am
- Location: Benagaluru
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 16
- Joined: Wed Apr 30, 2014 1:27 am
- Location: Benagaluru
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
well thats the thing, If you would have mentioned oracle and the database and that datastage was installed with NLS, the first answer you would have got to set NLS_LANG, you do not have to set it in dsenv only, you can have it as environment variable as well. Both will work.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.