On 9 Dec 2018, at 10:16pm, Winfried <codecompl...@free.fr> wrote: > sqlite> CREATE TABLE waypoints (name text, latitude text, longitude text, id > INTEGER PRIMARY KEY);
If you expect to use this table in the long term, rather than just extract data from it, then define latitude and longitude as REAL. This will make searching and sorting easier. Similarly, you should probably define name as TEXT NOCASE. Again, it won't matter now but may do if you ever need to search or sort. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
