homepage Welcome to WebmasterWorld Guest from 23.20.61.85
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
MySQL data type for UK address
How many characters should I have room for?
djkaytee

5+ Year Member



 
Msg#: 3545892 posted 4:31 pm on Jan 11, 2008 (gmt 0)

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

 

8kobe

5+ Year Member



 
Msg#: 3545892 posted 5:02 pm on Jan 11, 2008 (gmt 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved