MySQL Substring does not give 4000 to Oracle
I am using a product called Guardium to move data from a MySQL database into Oracle. I have a MySQL table which has a text field 12000 bytes in length.
I have created functions such as
"A=substring(col1,1,4000)", "B=substring(col1,4001,4000)" etc.
The Oracle columns are defined as:
A varchar(4000),
B varchar(4000)
It works great except only the first 255 characters are showing in the Oracle columns.
Is there a length limit on substring, length or other functions which might explain the 255 character problem?
Thanks,
Evan
Subject
Views
Written By
Posted
MySQL Substring does not give 4000 to Oracle
3615
June 12, 2014 10:28AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.