When I try to display or assign a variable to an SQL Server database column of data type text, I receive an error message. Why?

SQL Server database columns of data type text are BLOBs (Binary Large OBjects). Unlike char and varchar data type columns which have a limit of 8,000 bytes (characters), BLOB columns can contain many gigabytes of text or binary data. BLOB columns are ideal for storing large amounts of text (like long paragraphs of information), or binary data (like images, sounds or motion videos).

Because text columns can contain such large amounts of data, they sometimes must be handled differently than regular char or varchar columns with ASP and ADO in order to retrieve the data from the database table.

If you are receiving an error when operating on a text column, you must use the GetChunk method of the Field object in ADO to extract the data.

Please see the following Microsoft Support Knowledge Base articles for more details on this issue. This article contains an example of how to use the GetChunk method to extract data from text columns.

http://support.microsoft.com/support/activeserver/Faq/Data/adofaq.asp?LN=EN-US&SD=gn&FR=0&qry=getchunk&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=MSALL#UsinGetC

http://support.microsoft.com/support/kb/articles/Q180/3/68.asp

  • 6 Users Found This Useful
Was this answer helpful?

Related Articles

Where can I find documentation for ServerObject's AspMail component?

This documentation can be found at: http://www.serverobjects.com/products.html For...

How do I upload files through my web pages?

You can use Software Artisan's SAFileUP. This is an ASP component that allows you to upload files...

What is PageCounter and how do I use it?

About Page Counter PageCounter is an object that counts and displays the number of times a Web...

How do I setup Microsoft Outlook Express to read my e-mail?

Follow these steps: Open Microsoft Outlook Express. From the Tools menu, click...

How do I setup Netscape Messenger to read my e-mail?

Follow these steps: Open Netscape Navigator. Click the Edit menu and then click Preferences......