Thanks for the correction/information! Merry Christmas and Happy New Year to you.
On Tue, Dec 27, 2016 at 9:48 AM, Richard Hipp <d...@sqlite.org> wrote: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users