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
 Transact-SQL (2000)
 Storing big chunks of text

Author  Topic 

superhero
Yak Posting Veteran

52 Posts

Posted - 2007-07-27 : 10:00:13
Hi

How can I let someone save about 10 000 - 20 000 characters in a field in SQL 2000? I looked at all the data types in SQL and the most they can do is obviously 8060. How can I overcome this? I need to store a lot of text and read it back into my app again.

Thanks

JoeNak
Constraint Violating Yak Guru

292 Posts

Posted - 2007-07-27 : 10:45:15
Take a look at text, ntext, image datatypes in BOL.
Go to Top of Page
   

- Advertisement -