Blob datatype equivalent

[chebbi]

Hi

In my application we have the resume upload feature where people can copy and paste their test formattted resume in a textarea and submit the form. Thistextarea content gets stored in a sql server2000 database. The problem is that the field in he database where this resume gets stored is set to nvarchar daatype which holds a max of 4000 characters. I would like it to change to adatatype which holds unlimited characters like blob datatype in oracle. Any help will be highly appreciated.
Badrinath Chebbi

http://www.bmchebbi.com

 

[tlbroadbent]

The Text data type is the Blob equivalent. However, using a text column will require significant changes to your code. You should read about Text and the various Text functions in SQL BOL before making the change.

The varchar columns can hold 8000 characters. If you don't require the double byte storage of Unicode you could increase the column character size by converting to varchar. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.