GeoNames Forum

When I create the tables like this :

CREATE TABLE timeZones (
CountryCode VARCHAR(2) PRIMARY KEY,
timeZoneId VARCHAR(50),
GMT_offset DECIMAL(3,1),
DST_offset DECIMAL(3,1),
rawOffset DECIMAL(3,1)
) CHARACTER SET utf8;

and then try and load the data from teh text file like this:

LOAD DATA INFILE 'timeZones.txt INTO TABLE timezones;

I get the following error:

ERROR 1062 (23000): Duplicate Entry ' ' for key 'PRIMARY'

I dont understand why I get this. If I query that table and show the top five results the CountryCode is only showing 1 letter rather than the two that you can see in the text file, it definately tab seperated from teh rest of the data in the file.

I would really appreciate some advise guys