Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Long VARCHAR fields truncated by ASP?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-14 : 10:01:37
James writes "I need to create comments fields well in excess of 255. And I seem to have no problem creating 1000 byte varchar fields, except when I view them via my ASP search programs or update screens they get cropped at 255.

The full data seems to be in the file. But it gets cropped either by ASP or by SQL server (We use SQL server 7).

I can't find any answers on the web related to this problem. What can you suggest? I don't want a bunch of 255 char fields that I have to string together because loading them with data will be a major pain."
   

- Advertisement -