Hello, there is a small application which uses MYSQL db and can also switch to sqlite In MySQL a table "prices" has a column "basicprice" which is decimal(7,4) I can store a price in form 1.500 there. Same table and same columns in sqlite with datatype float(7,4) stores this value like 1.5 It would be nice if there is a way to store in the same way as in MySQL with filling zeros.
Is this not possible with sqlite? I also tried type decimal(7,4) Only with 1,500 the zeros are there, but I do not want to store a comma in the db thank you regards Werner _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users