Page 1 of 1
Posted: Fri Nov 25, 2011 1:41 pm
by ray.wurlod
Don't trust what View Data shows you in regard to "un-American" characters. Use a viewer that can display the Euro symbol, accented characters, etc. properly.
Posted: Fri Nov 25, 2011 4:51 pm
by paultechm
Apply stringtoUstring(columnvalue,'UTF-8') and make column datatype as nvarchar
View data wont give the correct result ,please check the final out put (file or table)
Thanks
Paul Joseph
Posted: Mon Nov 28, 2011 3:22 am
by coface
paultechm wrote:Apply stringtoUstring(columnvalue,'UTF-8') and make column datatype as nvarchar
Hi Paul,
Our DataStage-developer will try this suggestion. I will come back with the result...
Rgds
Jan
Posted: Mon Nov 28, 2011 5:10 am
by coface
Hi Paul,
sorry to say: but that didn't help
Posted: Mon Nov 28, 2011 5:43 am
by paultechm
whats the value looks like in the table after applying this funcation .
Make sure that datatype is in nvarchar
Posted: Mon Nov 28, 2011 6:48 am
by coface
the value looks like an upsidedown questionmark...
Our datastage-developer just told me that this problem occurs only with parallel jobs - but not with server-jobs. Since I'm not a datastage developer I don't have any idea why this makes such a difference. Maybe it's a bug in parallel jobs?
I have opened a SR at IBM - hopefully they are able to tell us why this error occurs only with parallel jobs...
Rgds
Jan
Posted: Mon Nov 28, 2011 7:40 am
by paultechm
Whats your source and datatype used for reading? Are you checking in view data or table?
Posted: Mon Nov 28, 2011 8:01 am
by coface
the source is a database table (as described it's an external table which directly reads from a flatfile).
We have tried all kinds of datatypes: varchar (with and without extended unicode, nvarchar). None of those worked...
Posted: Mon Nov 28, 2011 8:11 am
by paultechm
Use DRS satge to read the data as varchar in transformer convert using the function and change datatype as nvarchar .
Posted: Mon Nov 28, 2011 8:36 am
by chulett
People, please...
Stop the love affair with the
Reply with quote option. Sure, quote someone when the need arises to make a point or ensure we all know who / what is being responded to but to quote
everything all the time? 
Use the big orange
Reply to topic 'button'.
Posted: Tue Nov 29, 2011 3:04 am
by coface
... as a matter of fact this problem only occured with parallel jobs but not with server jobs. Therefore the developer decided to use a server job as a workaround.
Thanks to all who discussed this issue with me..