Content area
In the view defined here, we've converted the resume field from the text data type into a varchar that can be up to 8,000 characters in length. (Note that this trick won't work in earlier versions of SQL Server. They limit the varchar type to 255 characters. Version 7, however, puts the cap at 8,000 characters.) You can then select from the view instead of the table, and get back up to 8,000 characters of your data.
Full text
If you're like just about every other SQL Server user, you've probably upgraded to SQL Server 7. If so, you might have noticed that some of your ASP sites have started behaving strangely. Specifically, you might be finding that the data that's being saved into the text fields of your database appear to be chopped off after about 255 characters.
Where did the data go?
Actually, there are a couple of possible culprits here. First, if you're presenting your data in a simple text box (), you'll find that it simply can't handle really long text strings. The easiest solution to this problem is to display your data in a