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

Reply via email to