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 |
|
tristanlee85
Starting Member
3 Posts |
 Posted - 2008-09-02 : 15:12:14
|
| I am using ColdFusion to store WDDX XML packets as text into my database. I have my columns set as "text" with a length of 16. It turns out I can't insert anymore than 64000 characters. With my calculations od this packet, I could be entering at most in the most rare situation a max of 175000 characters. What other options do I have to get all of this text to fit? |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-09-02 : 16:02:04
|
in 2005 varchar(max) is preferred over the text datatype. either one can hold way more than 64k chars though.post the DDL for your table. are you sure you are using the text datatype?
elsasoft.org |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-09-02 : 16:09:09
|
| If your data is XML, why not just store it in a datatype XML column?CODO ERGO SUM |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-02 : 17:54:54
|
quote:
Originally posted by jezemine
in 2005 varchar(max) is preferred over the text datatype. either one can hold way more than 64k chars though.post the DDL for your table. are you sure you are using the text datatype?
elsasoft.org
we use varchar(max) to pass large values to our SP. |
|
|
|
|
|
|
Storing large amounts of text