Help Center>
ROMA Connect>
Troubleshooting>
Common Data Integration Tasks>
Value of the Source Field of the tinyint(1) Type Is Changed from 2 to 1 at the Destination During Scheduled MySQL-to-MySQL Data Integration
Value of the Source Field of the tinyint(1) Type Is Changed from 2 to 1 at the Destination During Scheduled MySQL-to-MySQL Data Integration
Cause Analysis
The MySQL driver automatically identifies tinyint(1) as the bit type. Therefore, the field value is changed to 1 at the destination.
Solution
Change Connection Mode to Professional for the MySQL data source and add tinyInt1isBit=false to the end of the character string, for example, jdbc:mysql://ip:port/database?tinyInt1isBit=false.
Parent topic: Common Data Integration Tasks
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.