[thelist] Procrastinating Variables

[Joshua Olson]

----- Original Message -----
From: "Rob Smith" <rob.smith at THERMON.com>
Sent: Thursday, December 12, 2002 11:02 AM


> Greetings oh non-maleficent ones,
>
> ... that maybe counter intuitive since we know enough to do some damage...
> anyway. I have a problem that I've never seen before with SQL Server 2k.
>
> I've got a Column varChar(2056) that contains a bunch of text/links; the
> character count of this data is only 416. I'm calling it via ASP and
> displaying it normally too. However, it doesn't display the entire
contents
> of the cell.

It looks like it is displaying the first 254 of the 416 characters?  This
sounds like it may be a ADO problem or perhaps you have a Convert, Cast, or
Trim in the query or view?  What happens when the datatype is changed to
text?

-joshua