Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL ntext problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-27 : 09:15:53
Caesar writes "Hi there!

I have a problem, hope you can help.
I have a table, something like this:
Table: Products
ProductID int
CategoryID int
Description: ntext

I use a textarea input to insert data for Description, and it does well, however when I display the data I expect the data to be displayed the same way as I submitted data, for example:

"This is the product description here.
You can place all your description and product
features here."

Now when it is display the white-spaces and carriage returns are not maintained.

Is there a way of fixing this problem? And how does data get save using the ntext data type.

Thanks much for your answer!!

Caesar"
   

- Advertisement -