March 14, 2006 at 9:40 am
So I have tried to do an INSERT, Build Insert and BCP of a large text file (around 84k) and thought there was some kind of limit or restraint to how much data can be handled at one time. I have since learned that the default size for a NTEXT or TEXT column in SQL2000 is around 32k.
When I ask, how do I make it larger, I get no response or "it's complicated."
This is sort of annoying, I stopped storing my text files as flat files on the server and opted to store them in the database because I was told it would be more efficient. Well, now I have to change it back?
Can someone please help? I need step by step instructions on how to make a column accept up to 500K worth of TEXT. Also, a query statement that will not truncate the content would be nice.
table_1
col1 INT (primary key)
col2 NTEXT
March 14, 2006 at 9:44 am
According to BOL, the TEXT datatype can store up to 231-1 (2,147,483,647) bytes of data.
What error are you getting?
March 14, 2006 at 9:51 am
It's funny that the more people you ask, the more solutions you get. It turns out that the RETRIEVAL is getting truncated. I am testing right now, but in the tool that I am using (Cold Fusion), I need to specify that Long Text files be returned in the Site Administrator page (silly me for thinking something like that should automatically be set to yes).
Anyway, this thread may be closed. I will test and get back to you.
Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply