freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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')
-
Problems with image fields,
Matthew Gamble, 04/14/2002
- <Possible follow-up(s)>
- Re: Problems with image fields, Mike Kendall, 04/14/2002
- RE: Problems with image fields, Steve Brown, 04/14/2002
- Re: Problems with image fields, Matthew Gamble, 04/14/2002
- Re: Problems with image fields, Brian Bruns, 04/14/2002
- Re: Problems with image fields, Mike Kendall, 04/14/2002
- Re: Problems with image fields, Brian Bruns, 04/14/2002
- Re: Problems with image fields, Dave Brotherstone, 04/15/2002
- Re: Problems with image fields, Matthew Gamble, 04/16/2002
- Re: Problems with image fields, Franck Martin, 04/16/2002
Archive powered by MHonArc 2.6.24.