RE: error: saving to a ntext column becomes corrupted (???)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Yaz (anonymous_at_discussions.microsoft.com)
Date: 04/28/04 

Date: Tue, 27 Apr 2004 17:31:04 -0700

when ntext, text and image data values are larger than 8k they are stored outside the data page for the row via a pointer. therefore, they must be accessed differently.

see sql books on line for more info under managing ntext, text, and image data

Relevant Pages

  • Re: Managing ntext, text with a long text data
    ... "When the ntext, text, and image data values get larger, ... I believe this limitation is in the client API rather than in T-SQL ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Managing ntext, text with a long text data
    ... MSDN says: "When the ntext, text, and image data values get larger, ... work with ntext, text, and image data block by block." ...
    (comp.databases.ms-sqlserver)
  • Re: Trigger special tables
    ... To be more precise (my question about text, ntext, image): ... Can be done something within SQL server, ... > INSERTED and DELETED are only availible in the scope of the trigger. ... >> that it's not possible to read text, ntext and image data from these ...
    (microsoft.public.sqlserver.programming)
  • Update text filed error
    ... SQL 2000 ... The text, ntext, and image data types are invalid in this subquery or ... aggregate expression. ...
    (microsoft.public.sqlserver.programming)
  • Re: Pointers in delphi
    ... size needed to store the image data. ... then i need to copy data from another variable to this pointer. ... ImgDetail is widestring. ... point myimage to ImaDetail teh way am doing? ...
    (alt.comp.lang.borland-delphi)