Does anyone know how to get it around?
SQL Server Documentation Team
I thought that Varchar was limited to 255 characters...is this not the case?
Have I been using the cumbersome text datatype for nothing?
Varchar (and char...) is upped to 8000 bytes in 7.0.
MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only.
>>I've had this problem using old MS SQL ODBC drivers.
case?Quote:> I thought that Varchar was limited to 255 characters...is this not the
In SQL 6.5, yes (255).
In SQL 7.0, no (8000).
aaron bertrand [active server pages mvp]
Are we at a point where kindergarten children are going
to have to go through a metal detector before returning
from their recess or lunch break?
We have defined columns to hold 1000 chars (varchar(1000)) and from within
SQL we have no problem accessing all of the information in the column.
However, web pages (using ADO) are only receiving the first 255 characters.
Need help identifying the source of the problem and what to do to correct.