On 9 Dec 2018, at 10:16pm, Winfried <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
