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)
 insert textareadata into a DB

Author  Topic 

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2005-11-01 : 03:36:36
how do i need to define the col of the db so when i insert and then pull out the data all of the breaking lines that were in the textarea will remain?
thnaks in advance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Kristen
Test

22859 Posts

Posted - 2005-11-01 : 05:08:55
Data that you insert into a column with a data type of TEXT should fulfil that need (NTEXT if you have Unicode Text).

If you text will not be more than 8,000 characters use varchar(8000) instead - or if you have unicode text up to 4,000 character maximum then use nvarchar(4000)

Kristen
Go to Top of Page
   

- Advertisement -