GeoNames Forum

Hi All

I created the following table;

CREATE TABLE countryinfo (
iso_alpha2 VARCHAR(2),
iso_alpha3 VARCHAR(3),
iso_numeric VARCHAR(3),
fips_code character varying(3),
name character varying(200),
capital character varying(200),
areainsqkm double precision,
population integer,
continent char(2),
tld char(10),
currency char(3),
currencyName char(20),
Phone char(20),
postalCodeFormat char(60),
postalCodeRegex char(200),
geonameId int,
languages character varying(200),
neighbours char(50),
equivalentFipsCode character varying(10)
) CHARACTER SET utf8;

I then import my countryInfo.txt file into the table.

When I query this table with "select * from countryinfo LIMIT 10;"

I get the following output:

I swapped two columns around which resolved the issue