On Wed, 19 Dec 2018 10:55:11 +0000 Chris Locke <sql...@chrisjlocke.co.uk> wrote:
> Fields with '_no' are read as 'number' and so should be a number. > OK, that doesn't always work for 'telephone_no' (they usually start > with a 0 Lots of numbers are labels that aren't meant to be calculated on. Item number, part number, model number, serial number, order number. Anything that needs to be distinguished and isn't worth naming. It's never a good idea to store such numbers as numerical types. There's always a potential loss of information, be it the leading zero or embedded '-' or multiple '.' characters. Unless the "number" is a quantity, for compuational purposes it's text. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
