Welcome to WebmasterWorld Guest from 50.16.24.12

Forum Moderators: open

MySQL data type for UK address

How many characters should I have room for?

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

5+ Year Member



Hello,
How many characters do you typically allow for in a MySQL database field for a UK address?
Thanks,
Katie
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

My Threads

Hot Threads This Week

Hot Threads This Month