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 |
|
Apples
Posting Yak Master
146 Posts |
 Posted - 2010-10-12 : 11:39:23
|
| I'm using SQL Server 2000 Enterprise Manager. I'm having trouble with storing some data in a column. The column has a data type of nvarchar, with a length of 4000, which I've now learned is the max length you can have.I need to store data in the column that is longer than 4000 characters...is there a way to increase the size? Or is there another way to store it? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-10-12 : 11:47:50
|
| There is the TEXT object. Basically a "blob" style datatype. It is however a bit harder to manipulate (you need a pointer to the field). Search here for example of same (READTEXT, UPDATETEXT) |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-12 : 11:48:23
|
| Use text datatype.PBUH |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-12 : 12:07:27
|
 PBUH |
|
|
|
|
|
|
Store nvarchar data greater than 4000 characters?