On 12/27/16, Don V Nielsen <[email protected]> wrote: > Theory related question. I'm being argumentative, I know. But this > issue is in the same category as one discussed weeks ago. > > SQLite is, in a sense, typeless. All data is stored as text (ignore > blob). Correct? It is when one casts a column to something other than > text that triggers SQLite to treat the text differently.
Incorrect. SQLite stores content in memory and on disk in multiple formats, including 2's-complement integers, IEEE 754 floating point numbers, text formatted as UTF8, UTF16be, or UTF16le, and binary blobs. See, for example, https://www.sqlite.org/fileformat2.html#serialtype > > Disregarding auto-incremented key values, why have an integer key. Special optimizations apply to tables with an INTEGER PRIMARY KEY that make such tables particularly fast. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
