Devart Forums

Hello,

I have a mySQL table with a tinyint field. In the oracle table I have this field as a number. If I execute the batch move component then I have an error: field is not integer.

Is there a datatype in oracle for tinyint? Or is there another way to copy the data with different datatypes?

Thanks

Hello,

I have checked the data transfer with the help of the TCRBatchMove component at the tables with MySQL - TINYINT(4) and Oracle - NUMBER fields, and the data is transferred with no errors. Please make sure that the fields order in both DataSet's is the same and that you are using the latest MyDAC and ODAC versions. If the error repeats even on the latest versions with the correct fields order, please send the scripts for creating and filling the tables to alexp*devart*com and also specify your IDE version