FreeTDS / PHP 3.0.16 Fails on Large Insert

Brian Bruns camber at ais.org
Wed Aug 2 16:00:04 EDT 2000


This is a problem with TDS 7.0 with queries that cross the block size (512
bytes by default).  I could fix it if someone will send me a network dump
of the packets, otherwise I'll have to set up a test and do it myself
which I won't be able to get to for some time.

Brian

On Wed, 2 Aug 2000, Jon McDonald wrote:

> On MSSQL 7.0 we have a nvarchar field set to 2048 bytes.  The following PHP 
> code fails:
> 
> <?
> //$query = "INSERT INTO bi..test (test) 
> VALUES('111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111')";
> $id = mssql_connect("sqlbox", "username", "password");
> $result = mssql_query($query, $id);
> mssql_close($id);
> ?>
> 
> The 1's are repeated 1024 times.
> 
> Any suggestions would be appreciated.  Network sniffs show the data being 
> sent to the SQL Server from the PHP box.  However, the data is never 
> inserted into SQL and no error message is returned...
> 
> 
> Thanks in Advance!
> 
> ---
> You are currently subscribed to freetds as: camber at ais.org
> To unsubscribe, forward this message to leave-freetds-12294M at franklin.oit.unc.edu
> 
> 




More information about the FreeTDS mailing list