Appreciate your advice on the following:
1. How do I find out which character set is being used ?
2. How to change the character set to UTF-8?
3. Can the character set being changed for a particular job only ?
Thanks,
Datastage Character Set
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you do not have NLS enabled, the internal character set is ASCII.
If you do have NLS enabled, the internal character set is UV-UTF8.
Neither of these is negotiable.
What you can do, if you have NLS enabled, is to map between any other encoding used externally to DataStage into or out of the internal (UV-UTF8) character set.
Note that this answer is only correct for server jobs. A different mechanism is used in parallel jobs.
If you do have NLS enabled, the internal character set is UV-UTF8.
Neither of these is negotiable.
What you can do, if you have NLS enabled, is to map between any other encoding used externally to DataStage into or out of the internal (UV-UTF8) character set.
Note that this answer is only correct for server jobs. A different mechanism is used in parallel jobs.
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.