MySQL Forums
Forum List  »  Oracle

MySQL Substring does not give 4000 to Oracle
Posted by: Evan Ehrenhalt
Date: June 12, 2014 10:28AM

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?



Options: ReplyQuote

Written By
MySQL Substring does not give 4000 to Oracle
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.