Losing first four characters of a LONG

From: Jay Valdez <jay_at_dontspamme.com>
Date: Tue, 2 Oct 2001 10:37:15 -0700
Message-ID: <RZmu7.2107$3x.7518@news.bc.tac.net>

Hello,

As in my previous posts. I am an SQL Server person doing some proof of concept work in Oracle. Basically converting some components an existing *.asp application running off SQL Server to assess how it could be easily converted to Oracle (and still use *.asp)

Thanks for all the responses to my questions from all the folk.

I appear to be experiencing some sort of anomaly with short data in the LONG field. I am storing pretty much ordanary text (more like strips of HTML) code that I query from and assemble into various web pages. The longest text strip is abour 11,000 characters. I have been using the ADO GetChunk method to retrieve the data (in 8K portions).

I have noted that:

(1) When the data is short like "<HTML><BODY>", I end up with something like
"ODY>"
(2) When it is short, it is also possible to retreive the data without using
GetChunk --> rst.Fields("HTMLCHUNK").Value

Anybody have any idea why this is happening, and suggest a workaround.

I am using the Oracle ODBC Driver 8.01.06

Jay Received on Tue Oct 02 2001 - 12:37:15 CDT