Re: "Length" in table design view

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 11/24/04

  • Next message: Newbie: "Re: change date format" 
    Date: Wed, 24 Nov 2004 13:13:54 +0530

    When text and image datatypes are stored in SQL Server, data page stores 16
    byte pointer is stored that points to pages that stores the text\image data.

    > How can I
    > determine the appropriate length to set it to, based on how many
    characters I
    > expect the field to hold?

    ntext datatype can store upto 1073741823 characters.
    See more help on this in books online. 

    -- 
Vishal Parkar
vgparkar@yahoo.co.in | vgparkar@hotmail.com
  • Next message: Newbie: "Re: change date format"

    Relevant Pages

    • Re: [pointers and arrays]: The difference between an array name and a pointer
      ... No. p stores an array 6 of characters. ... but it can often be treated /as if/ it were a pointer. ...
      (comp.lang.c)
    • Re: How much intelligence?
      ... The brain has to be storing things ... A computer program that recognizes handwritten characters stores ... strengths of connections between the neurons (artificial neurons, ...
      (comp.ai.philosophy)
    • Re: How much intelligence?
      ... The brain has to be storing things ... A computer program that recognizes handwritten characters stores ... strengths of connections between the neurons (artificial neurons, ...
      (comp.ai.philosophy)
    • Re: How much intelligence?
      ... The brain has to be storing things ... A computer program that recognizes handwritten characters stores ... strengths of connections between the neurons (artificial neurons, ...
      (comp.ai.philosophy)
    • Re: Threads member variable access problem
      ... >User Interface Thread). ... >stores the list of string like this ... delete the pointer when finished. ...
      (microsoft.public.vc.mfc)