Hi,
i have a problem. when i import decimal numers
like 123,456789 then ist cutted to 123 after import in the database.
when i export i see ith right as 123,456789 with comma. looks exactly than my csv file.
Any idea?
Harald
Cutting decimals
may be related to http://bugs.heidisql.com/868.
Hi,
I have similar "issue".
When I insert data manually (into data tab) and I insert eg. "1.22", it inserts only "1" (my local decimal separator is "," and mysql decimal separator is ".")
Maybe it could first check if the users uses dot or comma (check last delimiter)
I have similar "issue".
When I insert data manually (into data tab) and I insert eg. "1.22", it inserts only "1" (my local decimal separator is "," and mysql decimal separator is ".")
Maybe it could first check if the users uses dot or comma (check last delimiter)
Yes, I could easily ignore the local settings of each user but I think this is not what the majority of users expect from HeidiSQL. Indeed, there may be quite a few preferring the english/american number format, but this is still subjective and I'm not going to ignore users from other countries.
Just a friendly reminder :
Please thread very carefully here. I have experienced nothing but grieffrom this subject. You think doubles are a problem? Wait till you get dates. And what happens when you work in international environments en you get appended sets where parts have '.' and others parts have ','. There seems to be no right solution. Satisfying one will immediately cause problems somewhere else.
Personally I would hail the day if ISO came to it senses and decided on one single format.
Good luck
Please thread very carefully here. I have experienced nothing but grieffrom this subject. You think doubles are a problem? Wait till you get dates. And what happens when you work in international environments en you get appended sets where parts have '.' and others parts have ','. There seems to be no right solution. Satisfying one will immediately cause problems somewhere else.
Personally I would hail the day if ISO came to it senses and decided on one single format.
Good luck
Please login to leave a reply, or register at first.