long text entered through text field

[mariebmk]

I have a textarea on a webpage where users copy and paste html code. The html I've been using to test this is about 30,000 characters. It goes into a database that tries to store it as a type ntext. From what i've read this should be able to store well beyond 30,000 characters, yet the text keeps being truncated. Anyone have any ideas why this data isn't being entered correctly?

Thanks!

Beth

 

[mrdenny]

What do you mean it's being truncated? What are you using to view the data?

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[mariebmk]

When I pull the data back out of the database it is not all there. What happens is the users enter in this long chunk of HTML, and then they can view what they have entered. Its not collecting all the data. I'm able to post it all into the textarea and submit with no issues, but when I pull it back out of the database the end is missing

 

[mrdenny]

Any idea how much data is being put into the database? You can put the returned data in Word and have it count the characters.

Are you sure it's not a problem with the data being entered?

The field should be able to hold over a Gig a data in it.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[mariebmk]

i'm not sure how much is actually getting in . .when I do a query on it I only get <long text> displayed. Most of it is, the html being entered has about 90% there. The data being entered is not the best html (the users just save a word document as html and copy and paste that code) but it doesn't seem to die an any specific point. I'll look at it more closely tomorrow while I'm at work to see if its a specific tag or anything like that.

 

[mrdenny]

You'll have to query the data in Query Analyser to view the data in the text field. Text and ntext fields can not be viewed in Enterprise Manager.

Denny

--Anything is possible. All it takes is a little research. (Me)