Does anyone know how to get it around?
Thanks,
Young Lee
by Young Le » Wed, 05 May 1999 04:00:00
Thanks,
Young Lee
by Alan Brewe » Wed, 05 May 1999 04:00:00
--
Alan Brewer
Technology Lead
SQL Server Documentation Team
by Hans Gild » Thu, 06 May 1999 04:00:00
>Thanks,
>Young Lee
by Charles Sai » Fri, 07 May 1999 04:00:00
I thought that Varchar was limited to 255 characters...is this not the case?
Have I been using the cumbersome text datatype for nothing?
Thanks.
by Tibor Karasz » Sat, 08 May 1999 04:00:00
Varchar (and char...) is upped to 8000 bytes in 7.0.
--
Tibor Karaszi
MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only.
>Thanks.
>>I've had this problem using old MS SQL ODBC drivers.
by Aaron Bertran » Sat, 08 May 1999 04:00:00
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]
http://www.swynk.com/friends/bertrand/
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?
_______________________________________________________
1. can not fetch more than 255 chars from varchar(1000) column
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.
Thanks.
3. varchar(7000) returns only 263 char
4. BLOB as parameter in a JAVA-UDF
5. can only fetch first 255 chars from varchar(1000) column
7. Varchar(1000) returns 255 char only in SQL 7
8. Opening a form by getting the form name from a table.
9. SQL/ASP and string with more than 255 chars