On 12/27/16, Don V Nielsen <donvniel...@gmail.com> 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
