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.