[Solved] Oracle to MySql: convert field LONG RAW

[AlessandroCic]

Hi

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

[Anonymous]

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

[AlessandroCic · Accepted solution]

Hello

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

Regards

Alessandro

[Anonymous]

Hello,

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

Best regards

Sabrina