Post reply

Data Type Storage Size

  • May 11, 2007 at 9:26 am

    #173601

    Hi All

    Iam new to sql and learning the different data types, but when it comes to storage size and bytes I am finding it abit hard to understand. Please can someone explain or point me in tthe right direction.

    Many Thanks

  • May 11, 2007 at 9:30 am

    #705870

    Books Online covers this fairly well.  That is where I would start reading.

  • May 11, 2007 at 9:34 am

    #705873

    tried that and seriously it doen not make sense to me.......need plain english.....

  • May 11, 2007 at 9:51 am

    #705888

    What doesn't make sense?  Tell us what you think you understand (or don't) and then we can fill in the blanks and increase your understanding.

  • May 11, 2007 at 9:55 am

    #705891

    I understand the data types that have to be allocated to a column but how does the storage size for eg. Int data type has 4 bytes allocated to it. Is that a fixed 4 bytes? and how is that 4bytes worked out in storage capacity and where is this stored apart from the db, assuming it is stored somewhere else?

    Many Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply