Page 1 of 1
Currency field shows zero instead 1000 or more in russian locale
Posted: 07.09.2018, 14:27
by dpetinov
Using 7.2.5 rc, PostgresPro 10 on Linux x64 in Lazarus.
Currency field shows zero when becoming 1000 and more.
Other Clients (SQLDB, jdbc) shows money normally
Not sure is that because of locale or not.
Re: Currency field shows zero instead 1000 or more in russian locale
Posted: 08.09.2018, 09:52
by dpetinov
Forry for the desinformation. SQLDB shows the same behaviour.
It's a problem of lazarus or freepascal may be
Re: Currency field shows zero instead 1000 or more in russian locale
Posted: 08.09.2018, 11:58
by dpetinov
Sorry again. Now checked SQLDB correctly - it shows bad symbols instead of space in russian locale money (separator between thousands and below)
but not zero as zeos does! It seems SQLDB more correct than zeos 7.2.5 rc...
Re: Currency field shows zero instead 1000 or more in russian locale
Posted: 09.09.2018, 11:46
by marsupilami
Hmmm - which field type do you use in the database? We would need like a correct test case.
Re: Currency field shows zero instead 1000 or more in russian locale
Posted: 10.09.2018, 09:15
by dpetinov
in postgres this type called money
Re: Currency field shows zero instead 1000 or more in russian locale
Posted: 10.09.2018, 09:21
by dpetinov
Besides, when in SQL select I cast it to numeric(10,2) in zeos it becomes float and shows correct value.
Then, hacking fieldtype to currency solves the poblem - but this is a hack of cause.