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.
Decimal separator in MS-SQL exports
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
Please login to leave a reply, or register at first.