Skip to Content.
Sympa Menu

freetds - MS SQL7 image data type...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Franck Martin <Franck AT sopac.org>
  • To: 'TDS Development Group' <freetds AT franklin.oit.unc.edu>
  • Subject: MS SQL7 image data type...
  • Date: Fri, 7 Sep 2001 17:47:08 +1200


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.




  • MS SQL7 image data type..., Franck Martin, 09/07/2001

Archive powered by MHonArc 2.6.24.

Top of Page