topic Re: Encoding WE8MSWIN1252 to AL32UTF8 oracle database in Talend Studio

Encoding WE8MSWIN1252 to AL32UTF8 oracle database

BS0612 — Sat, 16 Nov 2024 08:07:18 GMT

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?

Re: Encoding WE8MSWIN1252 to AL32UTF8 oracle database

fdenis — Wed, 13 Jun 2018 11:10:56 GMT

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

Re: Encoding WE8MSWIN1252 to AL32UTF8 oracle database

BS0612 — Mon, 09 Jul 2018 12:04:01 GMT

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