Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Bug: SQL Server FLOAT datatype generates wrong export SQL statements

matsg's profile image matsg posted 5 years ago in Import/Export Permalink
Hi,

When I run a SELECT query against our SQL Server, I use a FLOAT datatype in a particular field because it is, as opposed to a DECIMAL field, truly a float value (it's an average calculation). But when I try to export the rows and insert them into another database, HeidiSql generates wrong statements:

INSERT INTO "Events" ("StatAvgExtensionLen") VALUES (9,99929898352611);

Note that I'm using an sv-SE locale, where decimal points are commas. DECIMAL fields export correctly (with a decimal point), though.

Verified in 9.1.0.4940.
scholz's profile image scholz posted 4 years ago Permalink

Hi,

same problem in version 9.3.0.5067

MSSQL (float) => MYSQL (float)

export generates wrong output: INSERT INTO ctg_unit (code, valueDE, valueEN, basis, factor, verbal, ordNr) VALUES (16, 'mg', 'mg', 'g', 0,001, 'MilliGram', 160);

Please login to leave a reply, or register at first.