[freetds] php ms-sql image type retrieval problem

Shawn Greene sgreene at azorus.com
Thu Apr 10 08:59:28 EDT 2003


db-lib will probably work better for you.  imho. :)

-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org]On Behalf Of Will Saxon
Sent: Thursday, April 10, 2003 9:56 AM
To: FreeTDS Development Group
Subject: RE: [freetds] php ms-sql image type retrieval problem


I guess I should have listed that information..

I have compiled PHP 4.3.1 with the Sybase ct-lib option from the FreeBSD
ports collection. Code has been tested on a recent 4-stable and a
5.0-release-p6 machine. Should I be using db-lib? There was not an option
for MS SQL support, I figured it would be the same as the Sybase support. I
have FreeTDS 0.60 from ports also - there is no version 0.61 there at this
time. I am going to build 0.61 manually and rebuild PHP manually (with
the --with-mssql option) to see if it makes a difference.

Thanks for the quick response.

-Will

-----Original Message-----
From: ZIGLIO Frediano [mailto:Frediano.Ziglio at vodafoneomnitel.it]
Sent: Thursday, April 10, 2003 8:47 AM
To: 'FreeTDS Development Group'
Subject: RE: [freetds] php ms-sql image type retrieval problem


>
> Hello,
>
> I have been working for a short while trying to extend a
> small web application we have to store images in an SQL
> database. While the insertion script seems to work,
> attempting retrieval causes PHP to crash with a bus error
> "error_handler: Data-conversion resulted in overflow." -
> which I believe is actually FreeTDS complaining, not PHP.
>

What API are you using? mssql, ct-lib or dblib ?
How do you compile php ?
ct-lib have problem, you should get php 4.3.0 or later (previous have buffer
overflow problems and others)
Also get FreeTDS 0.61 version (latest).

> I have the PHP magic_quote_runtime, _gpc and _sybase turned
> on for the script. I have (almost) successfully used a text
> type field to store this data (seems to get truncated for
> some reason) so I believe my code is at least partially correct.
>
> I have found 1 message in the archive from December that
> indicates all quotes have to be quoted and NULL characters
> stripped at some point to keep this from happening. Will this
> not corrupt my output? I am not sure if the NULL character is
> valid or necessary for the file formats I am using (in this
> instance .png).
>
> -Will
>

bye
  freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




More information about the FreeTDS mailing list