Decimal separator

Jefte_Goes · January 17, 2018, 11:47am

When you generate a backup, the decimal fields are generated with “,” instead of “.”, on import the bank understands that it is another column.

Ex:

Insert into TableTest (Id, Description, Price) values (1, ‘Test’, 15, 33);

instead

Insert into TableTest (Id, Description, Price) values (1, ‘Test’, 15.33);

or

Insert into TableTest (Id, Description, Price) values (1, ‘Test’, CAST(15.33 AS Decimal(9, 2));

Alexander · January 19, 2018, 9:44am

Hello,

Could you please clarify what version of SQLBackupAndFTP do you use?

Jefte_Goes · January 19, 2018, 6:06pm

11.4.1

I resolved by changing the regional settings and languages of my machine (Windows).

The app is fantastic, but should not always do the casting in decimal value?

Alexander · January 22, 2018, 4:12pm

Good news. Thank you for the feedback.

Could you please clarify do you backup SQL Server databases?

Jefte_Goes · January 22, 2018, 5:33pm

Sqlserver 2008

Att
Jefté Goes

Alexander · January 23, 2018, 9:28am

Thanks for the clarification.

Could you please tell us, do you get any error messages during the backup? If yes, please send us the full text of this error message or a screenshot of this issue.