On Tue, 2005-06-21 at 00:13 -0400, Tito Ciuro wrote:
> Hello,
>
> When I add text to the database, it's getting truncated because
> SQLite is converting it to a number. For example, I enter "9.0", but
> SQLite stores it as "9".
>
> Is there a way to force the value to be inserted as string?
>
Make the declared datatype of the column TEXT.
Example:
CREATE TABLE t1(a, b INTEGER, c REAL, d TEXT);
INSERT INTO t1 VALUES(9.0,9.0,9.0,9.0);
SELECCT * FROM t1;
Results in:
9|9|9|9.0
--
D. Richard Hipp <[EMAIL PROTECTED]>
