inserting large number of chars into field

[lfc77]

I have a field that I want use INSERT INTO statements to enter data with 10000+ characters. Can anybody tell me how to do this?


Thanks,

lfc77

 

[amorous]

Better approach is guess is to first split the string and store it in an array...

Then you can insert the array elements in the database fields

and when retrieve back you can concatenate the string back...

Not sure whether its the better way to do or not...

-VJ

 

[SQLSister]

make the field a text or ntext datatype. Then you might need to use writetest and updatetext functions to manipualte the data.

Questions about posting. See faq183-874

 

[ESquared]

SQLSister was trying to say writetext

 

[SQLSister]

I was indeed. Although some students I know might enjoy haing a writetest function.

Questions about posting. See faq183-874