GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
plz schema description  XML
Forum Index -> Postal Codes
Author Message
Andreas



Joined: 26/09/2007 13:55:11
Messages: 5
Offline

Most users will probably import the data to PostgreSQL, using the text data type (which is sensible), but I've been loading it to MSSQL (really painful), and found that the place_name for some Canadian towns (esp. Hamilton) exceeds all limits. varchar(120) isn't enough, L9C Hamilton has 161 chars.
marc



Joined: 08/12/2005 07:39:47
Messages: 3990
Offline

Thanks, I will update the description.

Marc

[WWW]
 
Forum Index -> Postal Codes
Go to:   
Powered by JForum 2.1.5 © JForum Team