hi,

I have tried to use varchar(8000) and text in my SQL Server 7.0 to hold some text with the length less than 8000 characters.

I could enter a block of text in a form, then it was submited, saved into my database and displayed back on the web. The trouble was that it only displayed 4000 characters and cut off the rest of it.

I know when using varchar, i need to to: convert(text, comments) as [comments] in the SQL. Still doesn't work. By the way, i'm using PHP script.

Please give me some hints how to use data type or how to get all my text displayed.

Thank you so much in advance for any inputs.

trang