Hi,
I am migrating a MySQL 5.7 .sql dump file to Oracle 10g. I am using SQL Developer 2.1
The file contains JSON data (array) within a field with MySQL data type, mediumText
I want to convert that to LONG RAW so it is usable by Powerbuilder 7.0
But SQL Developer will not convert it to LONG RAW, only CLOB.
Is there a way to convert it to LONG RAW, perhaps through first modifying the data type within MySQL?
These are valid MySQL data types, https://dev.mysql.com/doc/refman/5.7/en/data-types.html
CHAR and VARCHAR
BINARY and VARBINARY
BLOB and TEXT
ENUM
SET
JSON
LONGTEXT
MEDIUMTEXT
TEXT
Thank you for reading and for any help you can offer!
Annie