Re: [sqlite] Strings vs Integers

[Dan Kennedy]

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

[sqlite] Strings vs Integers

[Scott Baker]

Internally does sqlite store the following SQL statements differently?


INSERT INTO table (foo) VALUES (1024);

vs

INSERT INTO table (foo) VALUES ('1024');

-- 
Scott Baker - Canby Telcom
RHCE - System Administrator - 503.266.8253

-
To unsubscribe, send email to [EMAIL PROTECTED]
-