Re: [sqlite] Rrepresentation of REAL type - answered!

2014-09-20 Thread TimeOfDay.nl
Adminer sets the precision directive. That's the correct answer. So it is PHP itself thats rounds to 14 decimals, as defined in php.ini. Adminer overrides it. On Sat, Sep 20, 2014 at 4:37 AM, Richard Hipp wrote: > On Fri, Sep 19,

Re: [sqlite] Rrepresentation of REAL type

2014-09-19 Thread Richard Hipp
On Fri, Sep 19, 2014 at 11:46 AM, TimeOfDay.nl wrote: > I am looking at my SQLite database in two ways: > > 1. from PHP, in my application, thru 'select * from table' statements and > the such > 2. from Adminer, as a database management tool > > When I look at a field

[sqlite] Rrepresentation of REAL type

2014-09-19 Thread TimeOfDay.nl
I am looking at my SQLite database in two ways: 1. from PHP, in my application, thru 'select * from table' statements and the such 2. from Adminer, as a database management tool When I look at a field that is type Real, and has the value of -41.29 as the entered value, the results differ. -