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 |
|
ZLA
Starting Member
6 Posts |
 Posted - 2005-11-10 : 22:02:58
|
| Has anyone read to / from a Text field where the the data is more than 120,000 characters? I know I could use the TSQL ReadText and WriteText fields if the number of characters were smaller.Thanks in advance. |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-10 : 22:31:25
|
| Is the problem at 120,000 specifically? We have plenty of stuff that is around 64K stored in TEXT that we manipulate without any special considerations (i.e. we don't using "chunking" from the application AFAIK)Kristen |
 |
|
|
ZLA
Starting Member
6 Posts |
Posted - 2005-11-11 : 00:07:46
|
| per books online, below certain sizes, you can store the text in the data row and use normal access. For larger sizes, you can use readtext, writetext for text around 120,000 characters. Beyond that (up to the max of 2Gb), I think you would need to use some sort of chunking technique.However, I have yet to find an example. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-11 : 02:12:59
|
| Our application just does SELECT Col1, Col2, TheTextCol FROM MyTableand similarly with UPDATE/INSERT.For SELECT we put the Text Column on the end of the list (used to be a problem with old ADO drivers if it was in the middle, and I don't think this is necessary any more).If that doesn't work for you then I would suggest double checking the ADO version you have installed.But I haven't tried anything much bigger than 64KKristen |
|
|
|
|
|
|
Read Write Text Field for HUGE strings