On 23 May 2019, at 12:02pm, Dominique Devienne <ddevie...@gmail.com> wrote:
> On Thu, May 23, 2019 at 12:37 PM Simon Slavin <slav...@bigfraud.org> wrote: > >> IP addresses are easy: convert to the form aaa.bbb.ccc.ddd where each of the >> four parts is always three digits long. > > Sure. But representing it as 001.001.001.001 for 1.1.1.1 is not usual. You'd > better have a CHECK constraint to enforce your format. You misunderstood. This is a storage, selection and sorting format. Not one for interaction with users. Much like you would never show a user a number like 2348923.6484 without putting commas in or something. On 23 May 2019, at 4:35pm, Dominique Devienne <ddevie...@gmail.com> wrote: > C:\Users\ddevienne>ping 10.65.9.030 > Pinging 10.65.9.24 with 32 bytes of data: OMG. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
