<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "CountryInfo and GeonameID Column seems to be offset."]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "CountryInfo and GeonameID Column seems to be offset."]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>CountryInfo and GeonameID Column seems to be offset.</title>
				<description><![CDATA[ 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:

<a href="http://s187.photobucket.com/user/Robstar1512/media/countryinfo_geinameID_result.jpg.html" target="_new" rel="nofollow"><img src="http://i187.photobucket.com/albums/x159/Robstar1512/countryinfo_geinameID_result.jpg" border="0"></a>]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/4678.page#13092</guid>
				<link>http://forum.geonames.org/gforum/posts/list/4678.page#13092</link>
				<pubDate><![CDATA[Sun, 8 Dec 2013 20:05:18]]> GMT</pubDate>
				<author><![CDATA[ robnet]]></author>
			</item>
			<item>
				<title>Re:CountryInfo and GeonameID Column seems to be offset.</title>
				<description><![CDATA[ I swapped two columns around which resolved the issue]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/4678.page#13150</guid>
				<link>http://forum.geonames.org/gforum/posts/list/4678.page#13150</link>
				<pubDate><![CDATA[Sun, 15 Dec 2013 08:42:53]]> GMT</pubDate>
				<author><![CDATA[ robnet]]></author>
			</item>
	</channel>
</rss>