[plt-scheme] storing exact values in sqlite3?
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