[plt-scheme] storing exact values in sqlite3?

From: Mike Eggleston (mikeegg1 at mac.com)
Date: Mon Jul 13 17:32:45 EDT 2009

Morning everyone (morning somewhere),

When using sqlite3 for storing data if I have a table (and I'm just typing here)

sqlite> create table data (
  x integer not null
);

then

sqlite> insert into data values (3);
sqlite> insert into data values (7/5);
sqlite> select * from data;
3
1

The number 7/5 is an exact value, though is not an integer. How are exact
numbers stored as fractions in sqlite3? Must I use a text data type and
convert the values into and out of sqlite3?

Mike


Posted on the users mailing list.