Devart Forums

although the data are equal, marks them as different.

See Image
http://www.lastplayer.com/error_comp_data.jpg

Could you please provide us the CREATE definitions of the tables and let us know what types of data are stored in the columns?

I delete the tables and then created with schemacompare /sync

A double data type


CREATE TABLE qf.historico (
HST_ID int(11) NOT NULL AUTO_INCREMENT,
HST_CODISIN varchar(50) DEFAULT NULL,
HST_Fecha date NOT NULL,
HST_Cierre float(15, 6) DEFAULT NULL,
HST_CodVisualChart varchar(50) DEFAULT NULL,
PRIMARY KEY (HST_ID, HST_Fecha),
INDEX HST_CodISIN (HST_CODISIN),
INDEX HST_CodVisualChart (HST_CodVisualChart),
INDEX HST_Fecha (HST_Fecha),
INDEX `HST_ID,HST_Fecha` (HST_ID, HST_Fecha),
CONSTRAINT historico_ibfk_1 FOREIGN KEY (HST_CODISIN)
REFERENCES qf.fondos (FON_ISIN) ON DELETE CASCADE ON UPDATE CASCADE
)
ENGINE = INNODB
AUTO_INCREMENT = 60226834
AVG_ROW_LENGTH = 67
CHARACTER SET utf8
COLLATE utf8_general_ci;

Unfortunately, we were not able to reproduce this issue.

Will it be possible to send us the data specified on the screenshot you provided through exporting data to SQL or CSV format?

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.

We would like to let you know that we have released a new version 6.3 of dbForge Studio for MySQL where this issue is fixed http://www.devart.com/dbforge/mysql/stu ... nload.html

Thank you for your help in improving dbForge Studio for MySQL.