We've spent quite a lot of time trying to find out how best to insert data
into SQL Server TEXT (blob / long text) fields.
We found something on the Microsoft site but it didn't seems particularly
Basically, this is our situation:
We have a website. We use ASP and Stored Procedures to insert data. We need
to insert more than 8000 characters to one field so are going to have to
change a field from VarChar to a TEXT field.
But we can't find out how we'll insert into this text field.
We also currently search against this field - will this change when we
convert from varchar to text?
Thanks in advance