Troubleshooting
Problem
This error is common when working with multi-byte character sets. Usually this is due to the Oracle database being setup to accept data (column semantics) in byte instead of char. An example is DataStage is setup for UTF-8 and expects multi-byte data, when it comes in a column defined as 30 characters could (worst case) take up 90 bytes, however the Oracle Database may be set up for that column as only 30 bytes, not 30 characters.
[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.5;8.1;8.0;7.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
25 April 2025
UID
swg21447047