On Thu, 20 Dec 2018 15:42:27 +0000 Chris Locke <sql...@chrisjlocke.co.uk> wrote:
> and a model number is a numeric number My phone's model number is VVX 500. > set the column affinity to the type of data Yes, and not everything that looks like a number is a number. Some things that start out looking like numbers change over time in ways that make them non-numeric. If the assigning body didn't intend the "number" as a quantity, it's not. Treating it as such will often come to tears. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
