Four Stars

Encoding WE8MSWIN1252 to AL32UTF8 oracle database

Hello,

I have to read data from an oracle database what is encoded in WE8MSWIN1252 and write this data to an oracle database what is encoded in AL32UTF8. The size of a field is 1000 byte (input and output). When I start the Job, I get the error:

ORA-12899: Wert zu groß für Spalte "STG"."RSB_A200_INCOMING_T"."RUECKMELDUNG" (aktuell: 1015, maximal: 1000)
[ERROR]: rsb.test_rsb_incoming_v_0_1.test_RSB_Incoming_v - tOracleOutput_1 - ORA-12899: Wert zu groß für Spalte "STG"."RSB_A200_INCOMING_T"."RUECKMELDUNG" (aktuell: 1015, maximal: 1000)

Value to big for column. Has someone an idea to fix it?

1 REPLY
Nine Stars

Re: Encoding WE8MSWIN1252 to AL32UTF8 oracle database

find the data who is to big.

have a look at it.

It may be UTF char stored into ascii. they are using more places. some db allow it.

Regards

 

Francois Denis

Don't forget to tag when it's "solved"!