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 ACCEPTED SOLUTION

Accepted Solutions
Four Stars

Re: Encoding WE8MSWIN1252 to AL32UTF8 oracle database

I changed the Data_Type from VARCHAR2(1000 BYTE) to VARCHAR2(1000 CHAR) on the Table in DB, then it works.

2 REPLIES
Ten 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"!

Four Stars

Re: Encoding WE8MSWIN1252 to AL32UTF8 oracle database

I changed the Data_Type from VARCHAR2(1000 BYTE) to VARCHAR2(1000 CHAR) on the Table in DB, then it works.