SQL Server data storage

[Vijay Neelam]

I have problem with SQL Server text storage. I'm not able to store 255 chars
in text field.
Does any body please tell me is there any way to store large text > 100000
chars boths storing and retriving..
thank you
Viajy

 

[BJ Freeman]

I assume your are using ms-sql SERVER.
If so the largest varchar is 8000
You have to use ntext with a maximum length of 230 - 1 (1,073,741,823)
characters.
Look up your BOL it will help you.