On Mon, 2002-04-15 at 15:07, John wrote:
> Sure enough, the problem is with the CFM query.  It looks like ColdFusion 
> (which I am in no way responsible for) gets the data from the database 
> as a series of two-character hex representations of a single byte 
> (for instance, 65 for A).

This is the format I get if I bind a binary data item to a char string
with the Sybase libraries - I suspect that this is the same thing here,
and that ColdFusion is not binding this as a raw string. 

In general I've been able to avoid this by using a TEXT column instead
of an IMAGE column - this shouldn't make any difference, but I suspect
that the string binding for the fetch is different.

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
[EMAIL PROTECTED]           *or*          [EMAIL PROTECTED]
http://www.mbay.net/~mpeppler
International Sybase User Group: http://www.isug.com

Reply via email to