#1
  1. i don't do negative rep
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2006
    Posts
    760
    Rep Power
    705

    Arguments against using default data types


    a colleague of mine has created a table in Oracle to capture process data, but for reasons i don't fully understand has given all the fields their default data type, i.e. float for numerical and varchar(255) for string variables

    he refuses to acknowledge that this is overkill and that it would be more appropriate to select data types and lengths that fit the actual content of the fields better

    this colleague works in a different department, so there's no way i can tell him to change his table structure, that's why i need to find good arguments to try and convince him that it is bad practice to use default data types like float and varchar(255) across the board

    any ideas ?
    some character references
    universally acclaimed as "fundie of the worst kind"
    "the stubborn old loser whose high point of the day is making immature remarks and counting his rep points on an internet message board"
    stop bitching about lower case - it's my trademarkô
  2. #2
  3. Come play with me!
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    13,756
    Rep Power
    9397
  4. #3
  5. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,029
    Rep Power
    4210
    Originally Posted by marnixR
    ...for reasons i don't fully understand
    ... he refuses to acknowledge that this is overkill
    ... this colleague works in a different department

    any ideas ?
    just forget about the whole thing

    when he messes up (and there's no guarantee that he will), you can say "i tole you so"

    meanwhile, stop wasting your brain cycles on it, and go do something else
    r937.com | rudy.ca
    please visit Simply SQL and buy my book

IMN logo majestic logo threadwatch logo seochat tools logo