Bug 400471 - Importing floating point values from MDB file fails with German locale
Summary: Importing floating point values from MDB file fails with German locale
Status: REPORTED
Alias: None
Product: KEXI
Classification: Applications
Component: Migration/Import/Export (show other bugs)
Version: 3.1.0
Platform: Ubuntu Linux
: NOR normal
Target Milestone: 3.2.1
Assignee: Kexi Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-10-30 08:38 UTC by Wolf Behrenhoff
Modified: 2019-02-18 19:17 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Wolf Behrenhoff 2018-10-30 08:38:55 UTC 
SUMMARY
Importing MDB files with floating point values may fail depending on the current locale.

STEPS TO REPRODUCE
1. Have a standard Kubuntu installation with German language (or, I suspect, any other locale where the decimal point is not '.' but ',')
2. Import MDB file
3. Look at floating point values -> the digits after the decimal point are missing
4. Close Kexi
5. start a shell and run: LANG=C kexi-3.1 file.mdb
7. Import file again
8. Now have correct floating point values
Comment 1 Jarosław Staniek 2018-10-30 09:37:05 UTC 
Thanks for the report Wolf!
Comment 2 Jarosław Staniek 2019-01-17 00:04:44 UTC 
Hi Wolf,
I've tested KEXI by importing Northwind2003 database. It has orders.freight column of floating-point type. Tested de_DE and pl_PL. KEXI versions: 3.1.0 and 3.2.0 beta 1. Unfortunately can't reproduce the issue, values after the point are imported.

Is it possible that you create a small test Access file that reproduces the issue and double check if you used KEXI 3.1.0? You can attach here (compressed first).

Thanks.
Comment 3 Jarosław Staniek 2019-02-18 19:17:24 UTC 
Moving to 3.2.1 milestone since there's no feedback.