<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "isoLanguage Column in alternatenames table returns no values?"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "isoLanguage Column in alternatenames table returns no values?"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>isoLanguage Column in alternatenames table returns no values?</title>
				<description><![CDATA[ Hi All

Im new to geonames DB and a noob in Mysql but im sure I will enjoy this forumn :D

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 :D

]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/4672.page#13082</guid>
				<link>http://forum.geonames.org/gforum/posts/list/4672.page#13082</link>
				<pubDate><![CDATA[Sat, 30 Nov 2013 17:43:05]]> GMT</pubDate>
				<author><![CDATA[ robnet]]></author>
			</item>
			<item>
				<title>Re:isoLanguage Column in alternatenames table returns no values?</title>
				<description><![CDATA[ Solved this issue]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/4672.page#13093</guid>
				<link>http://forum.geonames.org/gforum/posts/list/4672.page#13093</link>
				<pubDate><![CDATA[Sun, 8 Dec 2013 20:05:21]]> GMT</pubDate>
				<author><![CDATA[ robnet]]></author>
			</item>
	</channel>
</rss>