Issue with pound symbol from source xml

ramsubbiah · Post by **ramsubbiah** » Thu Jun 02, 2011 5:47 am

Hi Dawar,

We are also facing the same problem, we are getting pound symbol from source xml, since NLS is not installed we are not able to convert the pound symbol.

Hi ray,

can you please advice us if any workaround for this issue.

Thanks,
Ram.

chulett · Post by **chulett** » Thu Jun 02, 2011 7:32 am

[split from this topic]

Let's get you into your own topic. Please edit your post to let us know your particulars, version and O/S. And let's start off by posting your job design and examples of your input & output.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 02, 2011 4:47 pm

Just to be clear, when you say "pound symbol" do you mean the currency symbol (₤) or the sharp sign (#)?

ramsubbiah · Post by **ramsubbiah** » Thu Jun 02, 2011 9:17 pm

ray.wurlod wrote:Just to be clear, when you say "pound symbol" do you mean the currency symbol (₤) or the sharp sign (#)? ...

Hi Chulett\Ray

Apologies for the late response

we are using datastage 8.0.1
OS is UNIX
NLS is not installed.

Job Details,

we are receiving price information for the products in the form of XML,

Job Design:

MQ stage-----> XML input stage-----> Transformer-----> intermediate dataset.

for some products the ARTICLE_DESCRPTION column is having ₤ symbol,so after running the job we found its populating some invalid character for that ₤ symbol, since NLS is not installed its taking default character set as UTF 8,

Note: currently our jobs in production, we are trying to do some workaround to fix this issue but no luck, so please advice me if any alternative solution for this issue.

Recently we installed datastage 8.5 with NLS,so i developed the same job in 8.5 and changed the NLS setting to ISO-8850-1,its successfully reading the ₤ pound symbol.

Thanks,
Ram.