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

Updated on 2022-02-21 GMT+08:00

View PDF

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

Previous topic: FDI Fails to Obtain Data During Real-Time Kafka-to-MySQL Data Integration Although Data Exists in MQS Topics

Next topic: "The task executes failed.Writer data to kafka failed" Is Reported When the Kafka Destination Is Used over the Public Network