Thread: varchar?

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    4
    Rep Power
    0
    is it a bad practice to define all my "string" fields to varchar(255) to cater for expension?

    thanks
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    cpy,

    It is not a bad practise to define all your "string" fields to varchar(255).

    some advantages are their using varchar.

    the main advantage is
    "Trailing spaces are removed when the value
    is stored."

    This will improve your database access performence.

    see some sql book for details.




    ------------------
    SR -
    shiju.dreamcenter.net

Similar Threads

  1. syntax error
    By DQSJR in forum MySQL Help
    Replies: 2
    Last Post: December 31st, 2003, 01:28 PM
  2. why do i get this error when adding a table?
    By spybreak in forum MySQL Help
    Replies: 2
    Last Post: October 29th, 2002, 02:35 PM
  3. mysql SELECT with (varchar) variable
    By mr_fitz in forum PHP Development
    Replies: 5
    Last Post: September 9th, 2002, 11:44 AM
  4. char, varchar, blob?
    By madhats in forum MySQL Help
    Replies: 5
    Last Post: August 29th, 2002, 12:28 PM
  5. sql statement mistake that i can't find....
    By FaTTY in forum MySQL Help
    Replies: 2
    Last Post: September 1st, 2001, 08:16 PM

IMN logo majestic logo spyfu logo threadwatch logo seochat tools logo