<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Unable to add Primary Keys to TimeZones, Admin1Codeascii and FeatureCodes."]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Unable to add Primary Keys to TimeZones, Admin1Codeascii and FeatureCodes."]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Unable to add Primary Keys to TimeZones, Admin1Codeascii and FeatureCodes.</title>
				<description><![CDATA[ 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 :D]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/4753.page#13178</guid>
				<link>http://forum.geonames.org/gforum/posts/list/4753.page#13178</link>
				<pubDate><![CDATA[Sun, 15 Dec 2013 08:42:53]]> GMT</pubDate>
				<author><![CDATA[ robnet]]></author>
			</item>
	</channel>
</rss>