Re: [sqlite] float value increased as a text field

On 2 Aug 2011, at 5:52pm, Mathias Legerer wrote: > Thank you for clarification. If you need numbers accurate to the 1, use integers. Thats what they're for. Business applications for big businesses don't store money as floating point, they store it as integers. You get more than 17 decimal

Re: [sqlite] float value increased as a text field

Hi Richard, Thank you for clarification. And yes, you are right with the guess, that the customer wants to preserve that much digits ;) br, Mathias 2011/8/2 Richard Hipp : > On Tue, Aug 2, 2011 at 12:18 PM, Mathias Legerer > wrote: > >> Hi, >> I noticed a strange behaviour, when i have a table wit

Re: [sqlite] float value increased as a text field

On Tue, Aug 2, 2011 at 12:18 PM, Mathias Legerer wrote: > Hi, > I noticed a strange behaviour, when i have a table with a text-field > and i put a big float-number into it. > When stored, it is increased by one. > Floating-point numbers are approximations. Always. No exceptions. SQLite promise

[sqlite] float value increased as a text field

Hi, I noticed a strange behaviour, when i have a table with a text-field and i put a big float-number into it. When stored, it is increased by one. create table TEST (ordnr int primary key, ktoid TEXT); insert into TEST (ordnr, ktoid) values(0, 99104499464.0); SELECT ordnr, ktoid FROM TEST; 0|