Top "Postal-code" questions

A postal code is a series of letters and/or digits which is useful to identify the a particular region within a postal address.

RegEx for matching UK Postcodes

I'm after a regex that will validate a full complex UK postcode only within an input string. All of the …

regex validation regex-group postal-code
What is the ultimate postal code and zip regex?

I'm looking for the ultimate postal code and zip code regex. I'm looking for something that will cover most (hopefully …

regex zipcode postal-code
Address validation using Google Maps API

I have a task to validate addresses entered into a system I am currently creating. The system requires that address …

api geolocation street-address postal-code
I need to store postal codes in a database. How big should the column be?

I expect the column to be a VARCHAR2, in my Oracle Database. US Zips are 9. Canadian is 7. I am thinking 32 …

database oracle globalization postal-code
Best practices for storing postal addresses in a database (RDBMS)?

Are there any good references for best practices for storing postal addresses in an RDBMS? It seems there are lots …

database database-design types street-address postal-code
Is there common street addresses database design for all addresses of the world?

I am a programmer and to be honest don't know street address structures of the world, just how in my …

sql database-design street-address postal-code
Retrieving Postal Code with Google Maps Javascript API V3 Reverse Geocode

I'm trying to submit a query using the postal code to my DB whenever the googlemaps viewport center changes. I …

google-maps google-maps-api-3 geocoding reverse-geocoding postal-code
Is it a good idea to use an integer column for storing US ZIP codes in a database?

From first glance, it would appear I have two basic choices for storing ZIP codes in a database table: Text (…

database database-design types street-address postal-code
Where can I find a list of all UK _full_ postcodes including street name and their precise coordinates?

Where can I find a list of all UK full postcodes including street name and their precise coordinates? They should …

list postal-code
Where can I get postal codes for all countries?

I once read about an open source database for postal codes with geolocation data but now I can't remember its …

database geolocation gis postal-code