freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS
- From: <camber AT ais.org>
- To: TDS Development Group <freetds AT franklin.oit.unc.edu>
- Subject: Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS
- Date: Fri, 2 Jun 2000 07:50:36 -0400 (EDT)
This is the default text size, just do a 'set textsize <value>' to
increase it.
Brian
On Fri, 2 Jun 2000, 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?
>
> Is it possible to read the stored procedure via FreeTDS?
>
> Can you get a list of tables and columns via FreeTDS?
>
> --
> James Cameron (cameron AT stl.dec.com)
>
> ---
> You are currently subscribed to freetds as: camber AT ais.org
> To unsubscribe, forward this message to $subst('Email.Unsub')
>
>
-
Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS,
James Cameron, 06/02/2000
- <Possible follow-up(s)>
- Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS, camber, 06/02/2000
- Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS, tetherow, 06/02/2000
- Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS, camber, 06/02/2000
- Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS, Michael Peppler, 06/02/2000
- Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS, Sam Sam, 06/02/2000
- Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS, James Cameron, 06/04/2000
Archive powered by MHonArc 2.6.24.