Re: formatting of currency values in kmmsplits table

2022-11-15 Thread Chris via KMyMoney-devel
Apparently the Vietnamese dong is the second lowest. Which reminded me when we went there a few years ago and I paid at a restaurant. I recall it cost over 1.3 million dong for the meals or about $80 aud. Chris On 16/11/2022 8:40 am, Jack via KMyMoney-devel wrote: Just found this: https://tru

Re: formatting of currency values in kmmsplits table

2022-11-15 Thread Jack via KMyMoney-devel
Just found this: https://trulyfinancial.com/blog/lowest-currencies-2022/ The Indonesian rupiah is apparently only the third weakest currency in the world with 14,365.5 to the dollar. The Iranian Rial is 42,250 to the dollar, but at 1/3 the value of the rupia, it looks like ten digits sho

Re: formatting of currency values in kmmsplits table

2022-11-15 Thread Chris via KMyMoney-devel
Good point I hadn't considered currency exchange. This is why you ask why something  was implemented that way and not assume its unnecessary. Yes I am talking to you Elon ;) Chris On 16/11/2022 2:12 am, Thomas Baumgart via KMyMoney-devel wrote: On Dienstag, 15. November 2022 09:08:44 CET Ch

Re: formatting of currency values in kmmsplits table

2022-11-15 Thread Thomas Baumgart via KMyMoney-devel
On Dienstag, 15. November 2022 09:08:44 CET Chris via KMyMoney-devel wrote: > Thanks > > I have always used integer's, never floats or doubles, I realised back in > the 90's that was a mistake when implementing credit card transactions. > Rounding errors bite hard. > > I have always decided at

Re: formatting of currency values in kmmsplits table

2022-11-15 Thread Chris via KMyMoney-devel
Thanks I have always used integer's, never floats or doubles, I realised back in the 90's that was a mistake when implementing credit card transactions. Rounding errors bite hard. I have always decided at the start of a project what was the maximum precision needed, usually 2 decimal places

Re: formatting of currency values in kmmsplits table

2022-11-14 Thread Thomas Baumgart via KMyMoney-devel
On Dienstag, 15. November 2022 01:01:03 CET Chris via KMyMoney-devel wrote: > I was going through the database tables when a file was stored as sqlcipher. > > I came across something I haven't seen before and I was wondering why it was > that way > > Transaction values are stored as text string

formatting of currency values in kmmsplits table

2022-11-14 Thread Chris via KMyMoney-devel
I was going through the database tables when a file was stored as sqlcipher. I came across something I haven't seen before and I was wondering why it was that way Transaction values are stored as text strings but with unusual divisors. For example the value 18.95 may be stored as "1895/100" w