Skip to Content.
Sympa Menu

freetds - Re: Problems with image fields

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: Re: Problems with image fields
  • Date: 16 Apr 2002 17:29:19 +0000

If you look in the archive of the mailing list you will find my workarounds to make it work... I have posted many requests for help.

It seems indeed that there is a data convertion issue somewhere in freetds or php...

I have asked help to the list to have a look and try to pinpoint where is the problem, but this is first time I see Brian having a go at it. Thanks Brian...

Basically, I store an object package of a gif inside a varbinary field then retreive it by chunk (via a MSSQL procedure) and cut the object package header from the stream that I send to the browser.

And it works...
http://www.sopac.org/Data/Aerial/Snaps.html?setid=227

In the archive you will find the whole code to make it work.

If you store straight binary data and try to retreive it it looks like there is some character convertion happening, like a byte with 0 value being ignored or stopping the stream (but it is just assumption). And I have stored gif of less than 1kB so textsize is not an issue here.

I'd really like to have it fully working...

Cheers.
Franck AT sopac.org

On Mon, 2002-04-15 at 00:24, Brian Bruns wrote:
Wouldn't hurt, I'll see if I can't take a crack at it in the meantime.  
You said you were using TDS 7.0, current snapshot of FreeTDS, and PHP 4.1.2 
right?  Are you using --with-sybase or --with-sybase-ct?

I wont be getting to it tonight but hopefully I can look at it tomorrow.

The other thing to try, and this may be quicker, is to compile PHP as CGI 
and then run it under gdb, when it segfaults to a 'bt' or 'where' to get 
the stack trace and post it.  That will tell us whether it is crashing 
inside freetds or php.

Brian

On Sun, 14 Apr 2002, Matthew Gamble wrote:

> Thanks.  It now works from sqsh, but still seg faults apache.  I am
> setting textsize inside the stored proc, so I know it is now getting set.
> 
> I assume now that this is a PHP issue, and not a freetds issue?  Should I
> file a PHP bug report?  I'm using PHP 4.1.2
> 
> Regards, 
> 
> M. Gamble
> 


---
You are currently subscribed to freetds as: [Franck AT sopac.org]
To unsubscribe, forward this message to $subst('Email.Unsub')



Archive powered by MHonArc 2.6.24.

Top of Page