Load from AS400, record with special character
Moderators: chulett, rschirm, roy
Load from AS400, record with special character
my job reads a DB2 table via ODBC and writes to an Oracle table (Oracle connector). some records with column (data type Char) containing special character x'6A' (EBCDIC broken vertical line) get rejected (ORA-12899: value too large for column). Your input is welcome.
Thuong
best regards
best regards
So just your typical characterset issue with multibyte data going into (I assume) Oracle fields defined using byte semantics. How are each field defined, source and target? Specifically wondering if you are writing to a CHAR(n) where it is actually defined as CHAR(n BYTE).
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers