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, 991000004499464.0); SELECT ordnr, ktoid FROM TEST; 0|991000004499465.0 I believe, this is just because of some conversion-library. Documenation says: "If numerical data is inserted into a column with TEXT affinity it is converted into text form before being stored" I thought that this would work without any problems, but it seems there is some limit for floats/real as text if you look at this bigger number: insert into TEST (ordnr, ktoid) values(3, 99100000449946222.0); -> 3|9.91000004499462e+16 Is there some documentation about this limit? Is it system-dependend? I am working on WinXP 32Bit. Thank you for any information. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
