TDS 7.0 with PHP

Michael Kimsal michael at tapinternet.com
Tue Aug 29 14:51:18 EDT 2000


Hmmm.... I don't know.  I just know that we're doing it.  :(

Sorry...  I think we've got SP1 on the SQL server.  Might that be an issue?

Steven Campbell wrote:

> Thanks for your reply, Michael.
>
> I have tried using TDS 4.2 or 5.0 against our SQL Server, but char or
> varchar columns > 255 bytes get truncated to 255 bytes, no matter what I
> do. I scanned MS's Technotes, and found articles saying that if you
> connect to a SQL Server 7.0 using TDS 4.2 or 5.0, the data gets modified
> on the fly to be compatible with the TDS protocol in use. Specifically
> columns longer than 255 bytes get truncated, and cursors and
> transactions get handled differently.
>
> What are you doing to get more than 255 bytes per row? I'd prefer to use
> TDS 4.2 if I could...
>
> Steven Campbell
>
> Michael Kimsal wrote:
> >
> > We've got php 4 and tds4.2 working against sql7 and are
> > dealing with columns over 255 bytes.
> >
> > I notice a sever slowdown when the info is over 500 bytes, but it
> > still works even then.
>
> ---
> You are currently subscribed to freetds as: michael at tapinternet.com
> To unsubscribe, forward this message to $subst('Email.Unsub')

--
==========================
Michael Kimsal
http://www.tapinternet.com
734-480-9961





More information about the FreeTDS mailing list