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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-01 : 09:19:17
|
| Alex writes "Hi...I'm working on SQL Server 7 and trying to store more than 8000 characters of text in a single database field. Clearly varchar(8000) isn't sufficient... but what about TEXT(16)? I can't change the size from (16) for some reason from the Enterprise Manager, and the Online Books don't seem to have anything at all on data types. The data has to come through a stored procedure, and I'm using the TEXT(16) type in there.The problem is that it only takes the first couple of pages of text.Is TEXT the right data type to be using here? I'm sure this is a problem that many people have, but I can't find any solutions anywhere.Any ideas would be greatly appreciated.Kindest regards,Alex" |
|
|
Jay99
468 Posts |
Posted - 2002-04-01 : 09:52:37
|
| The only thing larger than varchar(8000), for storing character data, is a BLOB, ie. TEXT. You do not specify the datalength for a TEXT datatype. (EM may show 16, but that is because it is implemented as a 16 byte pointer to the start of the BLOB on some other extent.)I would suggest you search the forum and sql team for 'text'. It has been discussed at length. If you have a specific question, post your ddl and dml that generates the error . . .Jay<O> |
 |
|
|
|
|
|
SQL Server 7 and Text Columns > 8000 characters