Search code examples
databaseoracleglobalizationpostal-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 characters would be reasonable upper limit

What am I missing?

[EDIT] TIL: 12 is a reasonable answer to the question Thanks to everyone who contributed.

Solution

  • Skimming through Wikipedia's Postal Codes page, 32 characters should be more than enough. I would say even 16 characters is good.