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