FreeTDS Development Group

[<camber AT ais.org>]

On Fri, 2 Jun 2000 tetherow AT nol.org wrote:

> 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.
>
Actually look in the syscomments system table.  Under sybase you would run
'defncopy' but I haven't seen a good freeware version of it anywhere.
 
> > 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/
>