Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:


Hi folks,
   I have a question. In a SqlServer 2000 db, I have a table which has a column that contains the following <longtext>
It has been my understanding that this is actually a pointer to another table that contains the data. And I do not find the data type defined for "longtext" in sql bol, (but do find it defined as a datatype in Access.)
I need to update these fields with new data.
What is the best way to do this??  And why can't I see all the data when I do a select in QA??
  • 2
  • 2
1 Solution

longtext is what you get when select from a "text" field.

not all the data is returned, because this kind of field can be huge.
however, if you are using the field in an application, other than QA
you WILL get all the data.

updating this field is done by sql statements like so:

update mytable
set myTextField = 'huge line of text'
bearpawsAuthor Commented:
Oh yes, we receive all the data in an application.
But I had noticed in QA I didn't receive it all nor do I see it all when I open the table in EM. And I thought the reason was because of its huge size. I wanted to be sure.
 I thought I would QA with an update statement to update the column with the new data.
Do you see any problems with this approach??
thanks :-)
QA has a column legth limit set to 256 characters by default, it can increased ti 8192. Limit of text field is above those limits - 2 GB (blob).

T-SQL has special commands for text:
which are incompatible with "text in row" table option.

UPDATE,INSERT commands can move unchaged text fieds from one table to another.

Usable ActiveX ADODB related to text:
Stream object
GetChunk,WriteChunk methods of Field
not really

you can just insert what you want in there.
selecting this column might be a bit annoying,
if you want to see the entire contents,
but inserting or updating should pose no prob.
Read "it can increased ti" as "it can be increased to". It is Friday afternoon ;)

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now