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))
Search found 2 matches
- Wed Feb 27, 2013 3:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Junk character inserted with Extended ascii in Netezza
- Replies: 3
- Views: 3578
- Sat Feb 23, 2013 2:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Junk character inserted with Extended ascii in Netezza
- Replies: 3
- Views: 3578
Junk character inserted with Extended ascii in Netezza
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 environmen...