Skip to Content.
Sympa Menu

freetds - Insert > 255 Char

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "McDonald, Jon" <jonm AT entrigue.net>
  • To: "'freetds AT franklin.oit.unc.edu'" <freetds AT franklin.oit.unc.edu>
  • Subject: Insert > 255 Char
  • Date: Thu, 30 Nov 2000 15:52:43 -0500


> I compiled FreeTDS (configure --with-tdsver=7.0 --enable-dbmfix) with TDS
> 7.0 support and the dbopen fix.
> The problem is that inserts over 255 characters still fail. PHP is aware
> that the db field is 1024 in length.
> Attempts to insert more than 1024 into the db result in an error message
> stating the data will be truncated.
> The field in question is an nvarchar of length 1024. Network sniffs show
> the client sending all the data to
> the server. It takes two packets to send the data. The sql server acks
> the first packet and then the client
> sends the second. I don't think this is a repeat of the original packet
> boundary crossing bug since the server
> acks the second packet also. In a nutshell the server is receiving the
> data but only accepting 255 chars of it.
>
> Any help would be greatly appreciated...
>
> Client Side:
> FreeBSD 4.0-release
> Apache 1.3.12
> PHP 4.0.3pl1
> FreeTDS 0.51
>
> Server Side:
> NT 4.0 SP6a
> SQL 7.0 SP2
>
>
> Jon McDonald
> Entrigue Systems, Inc.
> www.entrigue.net
> Voice: 404-406-4064
> Email: jonm AT entrigue.net
>



  • Insert > 255 Char, McDonald, Jon, 11/30/2000

Archive powered by MHonArc 2.6.24.

Top of Page