Re: [sqlite] Manifest Typing question

[D. Richard Hipp]

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]>