Skip to Content.
Sympa Menu

freetds - Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: tetherow AT nol.org
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS
  • Date: Fri, 2 Jun 2000 10:10:07 -0500 (CDT)


On 2 Jun, James Cameron wrote:
> G'day,
>
> My data is being truncated to 4096 bytes.
> PHP 3.0.15 to Microsoft SQL Server via FreeTDS from CVS.
>
> I'm developing something based on a stored procedure name provided to
> me, about which the author states "returns two fields, case_id
> (CHAR_P:255) and case_history (CHAR_P - Multi Line field)".
>
> Using PHP's sybase_fetch_row function shows the field returning with a
> length of 4096 bytes. The sybase_fetch_field function also says 4096.
>
> I went looking at php-3.0.15/functions/sybase.c and at freetds/src/dblib
> and freetds/src/tds but was unable to find any significant reference to
> 4096 bytes. Is there such a limit? If so, where can I adjust it?
>
> Is it possible that the author has made this limit?

I believe Brian has already answered this one.

> Is it possible to read the stored procedure via FreeTDS?

I would really like to hear the answer to this one.

> Can you get a list of tables and columns via FreeTDS?

Try invoking the stored procedures 'sp_tables' for a list of know tables
in the database and 'sp_columns tablename' for the columns in the
table. I know these work in MSSQL but am unsure as to whether sybase
is the same.

------------------------------------------------------------------------
Sam Tetherow tetherow AT nol.org
Director of Development
Nebrask@ Online http://www.nol.org/






Archive powered by MHonArc 2.6.24.

Top of Page