|
|
Posted by Rod on 07/06/07 15:25
Under SQL 2000 I have a table that consists of a single column of text
type, each record holds about 15-25,000 chars. This data happens to be
an xml, and I want to write this records to a text file. In order to
accomplish this i'm using ISQL.exe, but i'm finding that some of the
text type records aren't being written complete (truncated at 8k
chars).
I have tried increasing the width of columns (-w), and the maximum
text size (-x) {the maximum length of text data to return} parameters
for executing ISQL with no luck. High values make it crash.
Problems:
* If the data is longer than 8k, the text is truncated at 8k chars.
* If the data is longer than the value given for width of columns (-
w), an xml element might be separated in two when reaching the end of
line, making the xml invalid.
instead of :
....<data myId="1" myelement="2">...
i'm getting this if the element reaches the endofline
....<data myId="1" myel{LF/CR}
ement="2">...
Is there a way to write to a plain-text file the full contents of a
text field without having its contents being truncated? If not, a
workaround would be to output the text field in small chunks, any
guide to handle substrings and locate chars inside a text field?, will
be needing to seek and output complete elements "<... .../>"
Regards
Elias Willard / Rodrigo Perez
Navigation:
[Reply to this message]
|