Posted by Dan Guzman on 12/20/05 21:44

The number of bytes returned is controlled by the SET TEXTSIZE connection
setting. According the Books Online, the default is 4096 and ODBC sets it
to 2147483647 when connecting. Additionally, Query Analyzer limits the
column size according to the Tools-->Options-->Results setting.

In any case, a Profile trace should reveal the SET TEXTSIZE setting.

--
Hope this helps.

Dan Guzman
SQL Server MVP

<gene.ellis@gmail.com> wrote in message
news:1135107229.394633.213590@o13g2000cwo.googlegroups.com...
> Hello. I using a simply SELECT statement to retrieve some data from a
> SQL SERVER via an ODBC connection. I had to go from VARCHAR to TEXT
> because the amount of data. Anyway, my SQL statements worked just fine
> when I was using VARCHAR, but now since I am using TEXT, I am only
> receiving part of the content back. Do I have to do some sort of
> special Casting or something if I want to get all the content back?
> It's over 8,000 characters. Thank you very much. I have racking my
> brain on this for a while.
>

• Next in forum: Re: How do I use SELECT on a column with datatype TEXT?
• 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]