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

    Join Date
    Jun 2006
    Posts
    760
    Rep Power
    706

    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. Jealous Moderator
    Devshed Supreme Being (6500+ posts)

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

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo