…try for the languages. This works for mySQL and Firebird. (tested). It also filters out duplicates against a country (have seen dups), and filters out those countries with no language against them (have seen them also in the data).
…e first line as header and the data follows. all fields are surrounded with " " all fields are seperated with ,
a) geonameId field name being wrong. b) apostrophe was not escaped correctly. Fixed bug in both Firebird and mySQL where both database fields are to small for languages as the largest so far is 87 characters. made field 100 to try and handle future entries that might grown.
…the firebird opensource database : http://www.firebirdsql.org/. Tested with version 2.5