Is it really being converted, or is it simply a deficiency in the data viewer?
That is, is the registered trade mark character successfully being processed into your target? DO NOT rely on what the Data Browser is showing you - it is quite limited in the characters that it can display.
How to read special character in Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: How to read special character in Datastage
If you are seeing these special characters as '?' in your target table/file (don't use DataStage data viewer to validate.), then try changing NLS settings (try AMERICAN_AMERICA.AL32UTF8 or AMERICAN_AMERICA.WE8PC850 or NLS of your database)