issue with the eccentric characters

vamsi2508 · Post by **vamsi2508** » Sun Apr 24, 2011 6:33 am

Hello All,

Here is an issue with the eccentric characters [ `e ] . In the Unix box the source file is reflecting the eccentric characters as it is , with out any junk characters.

But after trying to read the data using a sequential stage (source) level it self,the VIEW DATA is reflecting some trivial junk characters.

for example,
**
D`ecor -- Source String

***
In this source string, the `e is getting replaced with some petty characters. Requesting any suggestions/knowledge base with lot many thanks..

greggknight · Post by **greggknight** » Sun Apr 24, 2011 12:54 pm

`e could be a spanish char
The ` for example determines gender of a noun it is used in names and such and removing the char changes the meaning of the word.

Thats one thing to look at.
If so you might need to handle spanish charecters.

ray.wurlod · Post by **ray.wurlod** » Sun Apr 24, 2011 4:41 pm

Don't believe anything that the View Data facility (data browser) shows you when dealing with accented characters. It was clearly written for a market (US English) that does not have them.

chulett · Post by **chulett** » Mon Apr 25, 2011 6:50 am

As noted, stop trusting the 'view data' utility for multibyte characters - what does the data look like in your target using a tool other than DataStage's viewer?

vamsi2508 · Post by **vamsi2508** » Mon Apr 25, 2011 9:51 pm

yes..in the unix box it is appearing as it is. even when i try to load it into a DB2 (target) database also no problem. But, when that string with eccentric character/s enter/s the Datastage Environment, it changes.