Encoding WE8MSWIN1252 to AL32UTF8 oracle database

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

View solution in original post


All Replies
Highlighted
Thirteen 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!

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

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Downloads and Trials

Test drive Talend's enterprise products.

Downloads