<<<No such thing as decimal(7,4) in SQLite. In sqlite studio you can configure a column a decimal(7,4) . but anyway, how can you store a price like 1.500 with numeric type?
2016-11-30 15:59 GMT+01:00 Tim Streater <t...@clothears.org.uk>: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
