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)

New User

10+ Year Member

joined:July 19, 2005
posts: 25
votes: 0

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)

Junior Member

5+ Year Member

joined:Sept 10, 2007
votes: 0

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.