On 4 Jan 2013, at 1:04pm, Igor Tandetnik <i...@tandetnik.org> wrote:
> Have your program keep a list of already-inserted countries, complete with > their IDs, in memory. Look up against this in-memory structure. There are > only about 200 countries in the world. Or just premake the table with the 200 countries in, and you should never come across any country not already in that table. It's ISO 3166, I think. Ah, here we go: <http://www.iso.org/iso/country_names_and_code_elements> 248 countries, with the internally-agreed forms of their names. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
