MS SQL7 image data type...

Franck Martin Franck at sopac.org
Fri Sep 7 01:47:08 EDT 2001


I'm having problems to render an image field as an image in php...

The image is saved raw in an image field in SQL 7.0. I have to convert the
image field into chunks of varchar(4096) before passing them to php, because
php-freetds seems not to like the data type image, secondly the TEXTSIZE is
limited to 4kB by default.... I know I can change it but it doesn't help...

It seems also that a GIF image is stored using twice the size.

I have succeeded to do it with an OLE encapsulated jpeg image, but I can't
make it with a GIF (I strip the OLE header by looking for the JFIF string).

Anybody has suceeded to store and retreive image using php-freetds-SQL 7.0

Franck Martin
Network and Database Development Officer
SOPAC South Pacific Applied Geoscience Commission
Fiji
E-mail: franck at sopac.org <mailto:franck at sopac.org> 
Web site: http://www.sopac.org/
<http://www.sopac.org/> Support FMaps: http://fmaps.sourceforge.net/
<http://fmaps.sourceforge.net/> 

This e-mail is intended for its addresses only. Do not forward this e-mail
without approval. The views expressed in this e-mail may not be necessarily
the views of SOPAC.




More information about the FreeTDS mailing list