UPDATE: RE: [thelist] Attack of the BLOB

scott.brady at homeqonline.com scott.brady at homeqonline.com
Wed May 23 16:21:15 CDT 2001


Joshua Olson wrote:

> Do the 19 characters reflect the original string in any manner?  If not,
> then the 36 hex values might be a reference to a location within the
> database heap, if it has one.  But this is just a guess.

When I convert the 38 Hex characters into the 19 string characters, they do
match  what the output should be (well, the first 19 characters anyway).

We ran a test to see if we were limited in how many characters we could pull
from an Informix text field with more than 255 characters.  We were able to pull
all of the data in such a field.

Our theory is that something in the drivers for Cold Fusion limits the amount of
data you can pull from a BYTE field in order to prevent an overflow (since the
BYTE field isn't limited in length).  While that makes sense, it doesn't make
sense to only be 38 Hex characters.

The Informix guru here (I can barely spell Informix) is going to work on a
procedure that will run the conversion process automatically and return a text
field. Hopefully, that should take care of it.

Scott





"Joshua OIson" <joshua at alphashop.net> on 05/23/2001 02:15:14 PM

Please respond to thelist at lists.evolt.org

To:   thelist at lists.evolt.org
cc:    (bcc: Scott Brady/TMS)

Subject:  Re: UPDATE: RE: [thelist] Attack of the BLOB


: The query is only returning 38 hex characters (19 string characters) on
that
: field, even though the field in the database has more than 38 characters
in it.
: (It seems to be consistent across the BLOB fields)
:
: Could there be some quirk in the informix drivers in Cold Fusion?  Or
could
: there be something I'm overlooking?


Do the 19 characters reflect the original string in any manner?  If not,
then the 36 hex values might be a reference to a location within the
database heap, if it has one.  But this is just a guess.

-joshua


---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !










More information about the thelist mailing list