GeoNames Forum

Hi All

Im new to geonames DB and a noob in Mysql but im sure I will enjoy this forumn

However I have managed to get the data imported and im checking the db integrity.

When I query my alternatename table the "isoLanguage" Column shows no data.

I downloaded the txt files from teh geonames website and I create the following table for the alternatename.txt data:

CREATE TABLE alternatename (
alternatenameId int PRIMARY KEY,
geonameid int,
isoLanguage varchar(7),
alternateName varchar(200),
isPreferredName boolean,
isShortName boolean,
isColloquial boolean,
isHistoric boolean
) CHARACTER SET utf8;

Anyone knwo what the issue might be or what im doing wrong? I appreciate your help

Solved this issue