Saving text/character data

[LohneB]

Good morning.

I have an application where MS SQL is used to save a large amount of data. I have a need to save a text field that exceeds 8000 characters. Is there an easy way to do this without extensive programming modifications to save the date in two or more fields?

Thanks for any help.

Bill

Bill Lohne
blohne@lohne.us

 

[johnherman]

I would use multiple records rather than multiple fields, with a sequence number for each record. Multiple records will be easier to manage than multiple fields. You could have the first record (aka sequence zero) stored in the master record and have all subsequent records (bytes 8001 and onward) stored in a subordinate file called, say, ExtendedText.



Sometimes the grass is greener on the other side because there is more manure there - original.

 

[LohneB]

Thank you - good suggestion. This should be very easy to do in my current environment..

Again, thanks.

Bill

Bill Lohne
blohne@lohne.us