Decimal separator in MS-SQL exports

[expired user #8440]'s profile image [expired user #8440] posted 9 years ago in Import/Export Permalink
I'm using HeidiSQL with a MS MSQL database. When exporting tables containing fields with MONEY data type, HeidiSQL creates a SQL statement like this:

INSERT INTO [table] (id, money_field)
VALUES (1, 9,9),
VALUES (2, 23,5);

Which of course fails when importing again. Unfortunately, this also happens when doing a database to database export. So right now I can't export the affected tables at all.

I found no export configuration or anything similar, so I thought posting here would be the best option.
Code modification/commit from ansgar.becker, 9 years ago, revision 4843
MSSQL: Return float values as expected by server. See http://www.heidisql.com/forum.php?t=16661
ansgar's profile image ansgar posted 9 years ago Permalink
r4843 fixes that.

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