<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "alternatenames data too long for colum in recent update"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "alternatenames data too long for colum in recent update"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>alternatenames data too long for colum in recent update</title>
				<description><![CDATA[ Hi,

I downloaded today the full geoname files and I got an error on importing geoname n° 290557 (United Arab Emirates) as the data provided for column alternatenames does not fit in a varchar(4000) as specified in the spec.

By the way I did download the full file a few days ago and it was not too long at that time : this means the update is recent.
But the modification date for the geoname is still 2009-09-17 => question : does an update only on an alternate name of a geoname NOT change the modification date ?

Best regards,

Nicolas]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1597.page#6632</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1597.page#6632</link>
				<pubDate><![CDATA[Tue, 10 Nov 2009 14:04:50]]> GMT</pubDate>
				<author><![CDATA[ nicolas.helleringer]]></author>
			</item>
			<item>
				<title>Re:alternatenames data too long for colum in recent update</title>
				<description><![CDATA[ Nicolas

Thanks for pointing this out. We have improved the automatic transliteration from foreign languages to ascii. The result of this transliteration is also included in the alteratenames list. This is the reason it was possible that the string was longer even though the toponym itself was not modified.
I have increased the size of the field in the doc to varchar(5000)

Best

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1597.page#6633</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1597.page#6633</link>
				<pubDate><![CDATA[Tue, 10 Nov 2009 21:03:19]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:alternatenames data too long for colum in recent update</title>
				<description><![CDATA[ And about modification date of the geoname when its alternate name is/are changed ?]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1597.page#6634</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1597.page#6634</link>
				<pubDate><![CDATA[Tue, 10 Nov 2009 21:19:10]]> GMT</pubDate>
				<author><![CDATA[ nicolas.helleringer]]></author>
			</item>
	</channel>
</rss>