BIG TROUBLE WITH STORING DATA INTO SQL SERVER 7.0,IN VB.NET

[ajay bharti]

hi all, i m working on a vb.net project. i have used SQL SERVER 7.0 as backend.To save an information into database i used varchar datatype that has 8000 length, i m in trouble coz a particular data field has more than 50000 char. how to save this field into data base. what should i do???? Please suggest me any logic to storing it. hi this ajay bharti

[Steve Pullan]

Try using a datatype of TEXT. Read up on it in the MSDN online help. ...Steve

[Briga]

Three options. 1) You chamge the datatype in something else (i.e. a text) or if you can't 2) You split the data into 7 fields each 8000 char or if you can't 3) You store your data in a different position (i.e. a file or another DB) and you put in your fied a reference to that information or.... 4) ..I don't know!