Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

MySQL data type for UK address

How many characters should I have room for?



4:31 pm on Jan 11, 2008 (gmt 0)

10+ Year Member

How many characters do you typically allow for in a MySQL database field for a UK address?


5:02 pm on Jan 11, 2008 (gmt 0)

5+ Year Member

I would suggest staying safe and allowing as much as possible. There are benefits to keeping values small, however I think it is a greater importance to have correct information. I would suggest varchar(255) however I am sure some would disagree. I know in the States I have encountered an address that was over 100 before multiple times on a site.

Featured Threads

Hot Threads This Week

Hot Threads This Month