Junk character inserted with Extended ascii in Netezza

[dsrajus]

Hi experts,

While loading special characters in netezza database, box character is inserted after one of special character Atilde (~ on top of A).

but when checking updating the netezza database directly, it is working fine. No such box character.

Problem is in Datastage 8.1, Is there any environmental setup to done to avoid this junk character?

Is there any other way of avoiding the junk character?

Thanks in advance

[dsrajus]

When using Basic transformer, I got this warning

Invalid character(s) ([xC6]) found converting string (code point(s): [xC6][xE8]) from codepage UTF-8 to Unicode, substituting.

trying to do Ereplace but it is also not working Ereplace(col.name, char(198),char(20))

[VineelPrem]

hi raju ,
APT_STRING_PADCHAR. I usually set its value to 0*20 (space).and trim space if necessary ,thus keeping my string clean

[chulett]

FYI - 0x20 is a space.