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

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch 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