DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Typical Data Items - Length/Size - Best Practices

  1. #1
    Join Date
    Jul 2005
    Posts
    5

    Typical Data Items - Length/Size - Best Practices

    Hi all,

    Sorry to post a question that I'm certain has been talked about somewhere (and hopefully on this message board so that you can just point me to the thread), but my searches have been waning and I digress.

    What I'm interested in finding information on has to do with setting up a database, and the best practices for data types (and much more importantly) maximum sizes for basic data items that repeat over and over again throughout projects. Items like first name, last name, address 1, city, ...etc. For instance, using MYSQL (my database of choice for any information I recieve), I've been pondering what data type and size to make the last name field for the database that I am creating.

    I obviously want to make it large enough to fit any last name but also as small as possible to conserve space and resources to allow for the possibility of explosive growth in the database. Since you have all almost certainly gone through this with each column of each table to make the db as well setup as possible...do you have any findings, threads, or links that can help me develop me system.

    Thank you in advance,
    Mike

  2. #2
    Join Date
    Jul 2005
    Posts
    5
    I can't believe that no one has responded to this!

    Reader's Digest Post -

    What DataType & Length do you use for the following pieces of information:

    First Name
    Last Name
    Address 1 / 2 (it would be interesting to know how you split this one up as well)
    City
    Email
    Phone

    and any more 'standard' data items that I'm not thinking of right now

    -Mike

  3. #3
    Join Date
    Dec 2003
    Posts
    2,750
    AFAIK there are no standards for size with respect to the types of data you mentioned. In addition, the size for address fields (and number of address fields) and phone numbers will vary if you're supporting the storage of international information.
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

Similar Threads

  1. BOND CONTROLS vs. UNBOND CONTROLS
    By saly in forum VB Classic
    Replies: 12
    Last Post: 02-02-2003, 12:27 AM
  2. Replies: 3
    Last Post: 12-29-2002, 11:05 PM
  3. sending binary data with XML
    By Joar Vatnaland in forum XML
    Replies: 0
    Last Post: 05-17-2001, 12:06 PM
  4. Replies: 7
    Last Post: 01-13-2001, 03:15 PM
  5. Complex Data Consumer Data Aware Classes
    By Desmond Cassidy in forum authorevents.kurata
    Replies: 3
    Last Post: 04-19-2000, 03:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center