need your help please

[AliHabib]

I want to enter data with lenght greater than 4000 char so I chossed ntext

but when insert data like :
"
my name is Ali, Have the following data:
1. dddd
3.fff
4.rr
the end
"

just insert my name is Ali, Have the following data: only

how can insert data with same formate without lossing data

[Delerna]

I presume you had that data separated into separate lines (like you have in your post)

Then the data would have been inserted into the table with multiple lines.

When you open the table, try increasing the depth of the rows so that more than 1 line can be displayed in each cell. You will probably see the rest of your data.