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)
 Data Types

Author  Topic 

oahu9872
Posting Yak Master

112 Posts

Posted - 2006-01-16 : 10:28:09
I am trying to build a function for users to insert articles into a database. I set the data type to text since the stories are long. The problem is they do not show up on the website. The data is still there in SQL server but internet explorer won't read it. The same is true for data type ntext. If I set it to varchar it works fine, but varchar has an 8,000 character limit which is not long enough for the articles.

Does anyone know why the text datatype won't show up?


Thanks

Frank Kalis
Constraint Violating Yak Guru

413 Posts

Posted - 2006-01-16 : 10:33:26
See if this helps: http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx (Especially the lower half)

--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt? http://www.insidesql.de/blogs
Go to Top of Page
   

- Advertisement -