In documentation for version 3.21.0:
in datatypes3.html
...
3. Type Affinity
...
Each column in an SQLite 3 database is assigned one of the following
type affinities:
TEXT
NUMERIC
INTEGER
REAL
BLOB
(Historical note: The "BLOB" type affinity used to be called "NONE". But
that term was easy to confuse with "no affinity" and so it was renamed.)
and in lang_createtable.html
...
CREATE TABLE ... AS SELECT Statements
...
The declared type of each column is determined by the expression
affinity of the corresponding expression in the result set of the SELECT
statement, as follows:
Expression Affinity Column Declared Type
TEXT "TEXT"
NUMERIC "NUM"
INTEGER "INT"
REAL "REAL"
NONE "" (empty string)
In the Expression Affinity table above, should the Expression Affinity
'NONE' be updated to 'BLOB' possibly with the explanatory 'Historical
note:' as per section '3. Type Affinity' in datatypes.html above.
NOTE: I have checked the current on line documents and they match the above.
For consideration.
Regards,
John
--
Regards
John McMahon
li...@jspect.fastmail.fm
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
