Post reply

text data type definition

  • May 1, 2003 at 10:13 am

    #159105

    If a field is typed as text, length(16) how many characters / bytes will it hold?

    Thanks

  • May 1, 2003 at 10:40 am

    #455920

    Go look at Books Online in the Transact-SQL Reference section and look at the article 'char and varchar'

    Michelle



    Michelle

  • May 1, 2003 at 10:46 am

    #455921

    I understand the length criteria for varchar,

    I do not understand how length relates to text data types.

    thanks

  • May 1, 2003 at 11:32 am

    #455927

    Sorry about that. Does this help?

    "Unless the text in row option is specified, text, ntext, or image strings are large character or binary strings (up to 2 gigabytes) stored outside a data row. The data row contains only a 16-byte text pointer that points to the root node of a tree built of internal pointers that map the pages in which the string fragments are stored. For more information about the storage of text, ntext, or image strings, see text, ntext, and image Data."

    See "creating and maintaining databases" The 'text in row data' subject. It shows how you can limit how much text someone is able to place in the text field if you have turned on the 'text in row' option for your table. Otherwise if you don't have 'text in row' turned on, then 16 bytes of your row are used to point to the text storage which can be up to 2GB in size.

    Michelle



    Michelle

  • May 1, 2003 at 1:45 pm

    #455940

    Thanks Michelle !!

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

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