On 30 Nov 2016 at 14:42, Werner Kleiner <sqlitetes...@gmail.com> wrote:
> 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 No such thing as decimal(7,4) in SQLite. Have a look at: http://www.sqlite.org/datatype3.html -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users