fred238 wrote:
Gerry Snyder a écrit :
fred238 wrote:
hello,
Is necessary to set column datatype in sqlite3 ?
Is better to use class storage in sqlite3 (TEXT, NUMERIC, INTEGER,
REAL, NONE) ?
Check out http://www.sqlite.org/datatype3.html and ask again here if
yu have further questions.
Gerry
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
already read it and i don't understand all
Ok, I will try to help a little.
You do not need to set data types. If you don't, the default affinity
will be NUMERIC. That is, anything that looks like a number will be
stored as an integer or a real, as appropriate. This can waste some time
if you want to use the value as a string, but in general should not be a
real problem.
Specifying datatypes may make things easier for some strongly typed
languages (I don't really know--I use Tcl myself).
But I think the only short answer to your "Is it better...?" question
is, "It depends."
Gerry
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
