Posted by Dan Guzman on 12/21/05 00:23

I don't know about your Easysoft Driver but the Microsoft SQL Server ODBC
driver sets the textsize value at 2GB. If the Easysoft Driver doesn't set
the textsize, it will default to 4096.

You ought to be able to issue an explicit 'SET TEXTSIZE 2147483647' in your
application to prevent truncation.

--
Hope this helps.

Dan Guzman
SQL Server MVP

<gene.ellis@gmail.com> wrote in message
news:1135116527.697886.169220@o13g2000cwo.googlegroups.com...
> Thanks for the reply. When I say "receiving part of the content" I am
> talking about in my application. I am using PHP to connect via ODBC
> (Easysoft Driver) to the SQL Server machines. I am reading the content
> back into a variable, and then displaying the variable. But the content
> is truncated. Do I have to do something special since I am reading in a
> text datatype? It reads in everything else just fine, and acted fine
> when this colum was a varchar datatype.
>

• Next in forum: Re: SQL/ASP - Timout Problem w/ Particular Statement
• Prev in forum: Re: How do I use SELECT on a column with datatype TEXT?
• Thread view: Re: How do I use SELECT on a column with datatype TEXT?

[Reply to this message]