Storing Long Text.................

  • Is this possible to store more then 8000 character in a column... In sql Server 2000.

    Plz.....It's Urgent

     

  • If you use a column type of text you can store up to 2gb of data.  There is good stuff in BOL on this.  Essentially your table stores a pointer to the BLOB

     

    Hope this helps.

     

    S

  • if u have any example then it's too good...

    I m using sql Server 2000 first time..

    Plz...

  • I really think you need to look in Books On Line it will give you a really good primer in using BLOBs

  • Hi, you could use an Image field.

    It also allows you to store up to 2GB of data.

    I've used this before for storing large amounts of text and it works like a dream.

    To insert the text you use a normal insert statement and to read it a normal select statement, no special formatting or functions needed.

    Hope this helps.

  • Image stores binary data, not text. For storing large amounts of text data use the text or ntext data types.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks to all of u....

    thanks a lot.

Viewing 7 posts - 1 through 6 (of 6 total)

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