GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register /  [Login] Login 
alternatenames data too long for colum in recent update  XML
Forum Index -> General
Author Message
[Post New]10/11/2009 14:04:50
    Subject: alternatenames data too long for colum in recent update
[Up]
nicolas.helleringer



Joined: 11/08/2009 13:48:39
Messages: 6
Offline
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
[Post New]10/11/2009 21:03:19
    Subject: Re:alternatenames data too long for colum in recent update
[Up]
marc



Joined: 08/12/2005 07:39:47
Messages: 4501
Offline
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
[WWW]
[Post New]10/11/2009 21:19:10
    Subject: Re:alternatenames data too long for colum in recent update
[Up]
nicolas.helleringer



Joined: 11/08/2009 13:48:39
Messages: 6
Offline
And about modification date of the geoname when its alternate name is/are changed ?
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team