Encoding WE8MSWIN1252 to AL32UTF8 oracle database

Five 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?


Accepted Solutions
Five 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.


All Replies
Eleven 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

Tag as "solved" for others! Kudos to thanks!

Five 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.