
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
[Solved] Oracle to MySql: convert field LONG RAW
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello
I did some tests and I found that the guy who works is the LONGBLOB
Regards
Alessandro

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello
I did some tests and I found that the guy who works is the LONGBLOB
Regards
Alessandro

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Thanks for letting us know the solution. We have selected your post as Best.
Best regards
Sabrina
