FreeTDS Development Group

[Franck Martin <franck AT sopac.org>]

When I tried to work to display images using php, I worked with images well below the textsize limit to avoid problem... I think I found several problems during the handling of image field formats, I don't know whose fault is it (php, freetds or mssql) but it gave weird results. Some of them includes 8 bits converted to 16bits, bytes containing 0 stopping the message flow, some characters are not transmitted....

All this seems weird to me, and as I'm not an expert in the freetds/php code, it would be very interesting if a freetds programmer look at this issue in particular. It seems to me from all the olds posts (more than a year), that I'm the only one having a working solution on mssql+freetds+php to display images...

Testers and debuggers this is a very important task.

I think you may find some errors on handling binary data inside freetds code?

Cheers
franck AT sopac.org

On Wed, 2002-01-16 at 17:35, Lowden, James K wrote:
> > From: Gonzalez, Zara E [mailto:gonzalze AT mail.slh.wisc.edu]
> > Sent: January 16, 2002 10:51 AM
> > 
> > I admit I am rather ignorant about MSSQL in general having 
> > used MySQL and Postgresql more...Recently I've switched to 
> > MSSQL...so please forgive my
> > ignorance, but what exactly is sqsh and MS isql?
>
> Zara, 
>
> Ignorance is OK.  Everyone knows something and no one knows everything.
> Please take a another look through the User Guide and FAQ, though.  There
> are references to SQSH littered all over the the FreeTDS docs.  
>
> Microsoft ships a command line utility called "ISQL" as part of their client
> tools.  It uses db-lib to communicate with the server, whereas the Query
> Analyzer uses ODBC.  Usually, that distinction is unimportant, but sometimes
> the differences surprise people.   
>
> Since you're new to MSSQL, you might have overlooked the @@textsize global
> variable.  You'll want to have a look through Books Online (ie, their docs)
> for it.  It controls how much of the image field is sent back at once, and
> the default value is sometimes 2 GB!  
>