ASP page only gets 255 chars when the column is varchar 7000 - SQL 7.0

ASP page only gets 255 chars when the column is varchar 7000 - SQL 7.0

Post by Young Le » Wed, 05 May 1999 04:00:00



Does anyone know how to get it around?

Thanks,

Young Lee

 
 
 

ASP page only gets 255 chars when the column is varchar 7000 - SQL 7.0

Post by Alan Brewe » Wed, 05 May 1999 04:00:00


Is the ASP page using a 2.65 or earlier version SQL Server ODBC driver?  SQL
7 would consider the older ODBC drivers to be pre-7.0 clients and would
truncate to 255 characters.

--
Alan Brewer
Technology Lead
SQL Server Documentation Team

 
 
 

ASP page only gets 255 chars when the column is varchar 7000 - SQL 7.0

Post by Hans Gild » Thu, 06 May 1999 04:00:00


I've had this problem using old MS SQL ODBC drivers.

>Does anyone know how to get it around?

>Thanks,

>Young Lee

 
 
 

ASP page only gets 255 chars when the column is varchar 7000 - SQL 7.0

Post 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.


>I've had this problem using old MS SQL ODBC drivers.

 
 
 

ASP page only gets 255 chars when the column is varchar 7000 - SQL 7.0

Post by Tibor Karasz » Sat, 08 May 1999 04:00:00


Charles,

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.


>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.


>>I've had this problem using old MS SQL ODBC drivers.

 
 
 

ASP page only gets 255 chars when the column is varchar 7000 - SQL 7.0

Post by Aaron Bertran » Sat, 08 May 1999 04:00:00


Quote:> I thought that Varchar was limited to 255 characters...is this not the

case?

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.

2. change system message...

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

6. Store procedure encrypted

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