topic Re: [Solved] Oracle to MySql: convert field LONG RAW in Talend Studio

[Solved] Oracle to MySql: convert field LONG RAW

AlessandroCic — Sat, 16 Nov 2024 00:55:58 GMT

I have to transfer data from an Oracle DB to MySql.

In the Oracle table I have a field type LONG RAW

I have to transfer the values to a new MySql table.

What type of field can I use?

I tried to use BLOB

But I have the error

Data truncation: Data too long for column 'IMAGE'

Reagards

Alessandro

Re: [Solved] Oracle to MySql: convert field LONG RAW

Anonymous — Mon, 21 Dec 2020 06:34:44 GMT

Hello,

Talend type of the column should be id_bytes, db type of the column should be long raw

You can create connection on Metadata on Repository view and right-click the connection, then press "Retrieve Schema". The DB type will be correctly mapped.

Best regards

Sabrina

Re: [Solved] Oracle to MySql: convert field LONG RAW

AlessandroCic — Mon, 28 Dec 2020 13:59:28 GMT

Hello

I did some tests and I found that the guy who works is the LONGBLOB

Regards

Alessandro

Re: [Solved] Oracle to MySql: convert field LONG RAW

Anonymous — Tue, 29 Dec 2020 04:00:55 GMT

Hello,

Thanks for letting us know the solution. We have selected your post as Best.

Best regards

Sabrina