Display Image Fields From MSSQL.

Brian Bruns camber at ais.org
Sun Mar 4 13:05:48 EST 2001


Nope image is strictly a 'blob' field.  It's just that when Sybase put the
feature in, hardly any other vendors had done so, so the names blob and
clob were not universal and they chose image/text.

Anyway, we should be doing whatever sybase/ms is doing with image->char
conversion, I just don't know what that is...I'll try it out at work
tommorow.

Brian 

On Sun, 4 Mar 2001, Steve Langasek wrote:

> On Sat, 3 Mar 2001, Brian Bruns wrote:
> 
> > PHP is attempting to convert an image type to a string.  Does anyone
> > know if this feature works in PHP? I'm not really sure what the behavior
> > of converting image -> char should be.  My guess is that it would be a hex
> > representation like binary/varbinary does.
> 
> PHP has 8-bit-clean handling of strings; it just needs to have a way of
> knowing how long the string is when you create it.  I imagine the most useful
> format in which to make the image available to PHP would be as raw 8-bit data
> (stored in a string).  If someone wanted it as a hex representation after
> that, they could convert it on their own, and if someone wanted to work with
> the raw image data (e.g., writing it to a file), they could do so without a
> double-conversion.
> 
> Does the TDS 'image' type imply any particular image format, btw?
> 
> Steve Langasek
> postmodern programmer
> 




More information about the FreeTDS mailing list