Unable to read €,£ characters from sequential file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
GJ_Stage
Participant
Posts: 131
Joined: Mon Oct 27, 2008 6:59 am

Post by GJ_Stage »

Hi ,

Did you get any error message while reading ? If so, Please provide the same to check.
chanaka
Premium Member
Premium Member
Posts: 96
Joined: Tue Sep 15, 2009 4:06 am
Location: United States

Post by chanaka »

What is the encoding you used when you are saving the file? If you want to read UTF8 data you have to be sure that you save it in that encoding.
Chanaka Wagoda
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

This may be an issue with the internal representation of the Euro symbol clashing with DataStage's internal representation of NULL (Char(128)). Can you please check your file to see whether that symbol is 0xA0 ?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply