Hi HemaV,
Your data source is using a different code page than your DataStage environment.
The pound Sterling sign is Hex A3 in the extended characters of the Latin 1 (8859-1) code table (the most commonly used code table). Your source and/or your DataStage environment is using a code table that has assigned a different extended ASCII character for that symbol.
You need to determine the code tables being used and either ensure they are the same by picking a common code page or performing a translation as part of your transformation logic.
Here is a link to the Latin 1 code table. http://cs.stanford.edu/~miles/iso8859.html
Is this the only character that is getting changed?
Rob
How to retain £ symbol
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: