Skip to Content.
Sympa Menu

freetds - RE: Image fields? freetds bug? testers and developers needed!!!

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: Image fields? freetds bug? testers and developers needed!!!
  • Date: 17 Jan 2002 09:14:29 +0000

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!  


  • RE: Image fields? freetds bug? testers and developers needed!!!, Franck Martin, 01/16/2002

Archive powered by MHonArc 2.6.24.

Top of Page