Help Center/ Data Replication Service/ FAQs/ Data-Level Comparison/ Comparison Precision of Float and Double Types in Value Comparison from MySQL to MySQL
Updated on 2025-07-24 GMT+08:00

Comparison Precision of Float and Double Types in Value Comparison from MySQL to MySQL

If the value comparison from MySQL to MySQL involves tables of the float or double type, the scale value of the corresponding column in the database table is preferentially used as the number of valid decimal places for comparison. If the scale value of the corresponding column obtained from the database is 0, the default comparison precision is 15 decimal places.