• (unregistered)

    It actually makes sense. Well, almost. Let me explain. During development I often wonder about different data-types used in many of the tables. And clicking about in Query Anylizer can be really annoying, you all must agree.

    I would sincerely change just one thing. Include the length value in the column name.

    That would even clarify the difference between varchar and varchar2 as clearly as possible.

    And one more thing. I hope whoever made that table is now in prison for life.


    ML


    p.s. Why varchar(1023)? Is that a magic number?

  • John Smith (unregistered) in reply to

    1023 is, indeed a magic number.


    It comes from 1024, being 2^10, the value of 1k of memory.  1023 comes from 1024 - 1 character for the end of line (\0).

    Welcome to computer science.

  • Journeying Developer (unregistered)

    Hello there my friends, I'm glad you could join me here at the end of my journey - it certainly has been an enlightening couple of months. Since the implosion of my last company in mid 2008 and my subsequent employment at a company that has no work for me to do, I have systematically read every single article ever posted to the site. Today I finally reached this post and so here I am, standing at the epoch of TDWTF.

    The journey has been long and costly - mostly for my new employer, who has spent thousands on paying my salary over the last couple of months. For me, it has been a veritable roller-coaster ride of learning, laughing, cringing and occasionally vomitting. And thanks to MFD, my MSPaint skills are almost up to MVP level.

    I'd like to thank everyone who has helped me to get here: Alex and Jake of course, Derrick, George and Mark and all the contributors that have helped to guide me on this spiritual journey.

    Alas, I am now forced to reconsider the direction of my working life. Am I truly prepared for the gap that will be left now that I have exhausted the archives? Worse still, am I going to have to do some actual work anytime soon?

    We'll cross that terrifying bridge when we come to it. Until then, I'd just like to say thank you for sharing this moment with me.

    -- xx

  • C (unregistered) in reply to John Smith
    John Smith:
    1023 is, indeed a magic number.It comes from 1024, being 2^10, the value of 1k of memory.  1023 comes from 1024 - 1 character for the end of line (\0).Welcome to computer science.
    That should be end-of-string (\0). :-B

    Also, it's magic since it's the smallest 4-different-digits natural number. ;-)

  • woot (unregistered)

    LAST!!!

  • foo (unregistered) in reply to woot
    woot:
    LAST!!!
    No.
  • Captcha:ingenium (unregistered) in reply to woot
    woot:
    LAST!!!
    Bullshit. Ten points from Gryffindor.
  • kotenok2000 (unregistered)

    picture from wayback machine. http://web.archive.org/web/20150505074322im_/http://www.papadimoulis.com/alex/tblDataTypes.jpg

Leave a comment on “tblDataTypes”

Log In or post as a guest

Replying to comment #:

« Return to Article