JetEntityFrameworkProvider icon indicating copy to clipboard operation
JetEntityFrameworkProvider copied to clipboard

Published 20 hours ago • verified publisher icon bubibubi

Decimal values ​​ignore the decimal separator and are saved as integer

Open gjojesus opened this issue 5 years ago • 3 comments

I usually use only single or double numbers, which has worked perfectly, but recently I built a system using decimal values ​​and saw that they are saved by ignoring the separator, that is, 4.9 is saved as 49. The same system works normally with decimal using SQL Server or switching from decimal to float using MSAccess. I believe it is a bug.

gjojesus avatar Jan 20 '20 13:01 gjojesus

It's a Microsoft Jet bug that happen only on some cultures. No way to fix it. You can see a similar issue here

https://github.com/bubibubi/EntityFrameworkCore.Jet/issues/32

bubibubi avatar Jan 20 '20 14:01 bubibubi

Thanks for your quick reply. I saw that issue and I was using pt-BR culture, so I switched to en-US hoping it would resolve, but the problem remained. I thought it was something else. Some work around or suggestion?

gjojesus avatar Jan 20 '20 15:01 gjojesus

Not really a suggestion but if you have a support contract you could try to contact Microsoft. You can find the code that uses only OleDb on https://github.com/bubibubi/EntityFrameworkCore.Jet/issues/32

bubibubi avatar Jan 20 '20 17:01 bubibubi