Post reply

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

  • March 13, 2007 at 4:52 am

    #176515

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

    Plz.....It's Urgent

     

  • March 13, 2007 at 5:02 am

    #694624

    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

  • March 13, 2007 at 5:11 am

    #694626

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

    I m using sql Server 2000 first time..

    Plz...

  • March 13, 2007 at 5:15 am

    #694628

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

  • March 13, 2007 at 11:33 pm

    #694854

    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.

  • March 14, 2007 at 12:33 am

    #694859

    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

  • March 14, 2007 at 1:11 am

    #694863

    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