Bug 400471

Summary:	Importing floating point values from MDB file fails with German locale
Product:	[Applications] KEXI	Reporter:	Wolf Behrenhoff <wolf.behrenhoff>
Component:	Migration/Import/Export	Assignee:	Kexi Bugs <kexi-bugs>
Status:	REPORTED ---
Severity:	normal	CC:	adam, inksi, staniek
Priority:	NOR
Version:	3.1.0
Target Milestone:	3.2.1
Platform:	Ubuntu
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:

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.