On Fri, 2007-08-10 at 09:28 -0700, Scott Baker wrote:
> Internally does sqlite store the following SQL statements differently?
>
>
> INSERT INTO table (foo) VALUES (1024);
>
> vs
>
> INSERT INTO table (foo) VALUES ('1024');
Depends on the type specified for 'foo' in the CREATE
TABLE statement. The answer is yes if the affinity of
the column is NONE.
http://www.sqlite.org/datatype3.html#affinity
Dan.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------