Hi! Just started using HeidiSQL in a new database project and I ran into this problem. My computer currently uses comma as a decimal separator and there is no way I can change it. The thing is that when exporting to clipboard or file HeidiSQL always generates invalid SQL statements because of the separator (","). For example:
INSERTO INTO "TABLE" ("ID", "NAME", "NUMBER") VALUES ("100", "MY_NAME", 12,10)
SQL seems to understand (as it should) that I'm declaring 3 columns and 4 values because of the "," separator.
I've already searched in the forums and no one seems to propose a good solution besides changing system settings. I can't understand the difficulty of putting a config section to define the language settings for this kind of stuff in the client.