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

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

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.

Joined: 08/12/2005 07:39:47
Messages: 4093

Thanks, I will update the description.


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