OleDbType for SQL Server Text?

  • Thread starter Thread starter xenophon
  • Start date Start date
X

xenophon

I have a column in a SQL Server 2000 table that is of type Text. That
is so I can put an unlimited-size string inside that column.

I am using the OleDb connector to put data in there, my pseudo code
looks ike this:

"@myparamname" , OleDbType.LongVarChar , 819200 ,
ParameterDirection.Input

But text seems to be truncated after about 1000 characters.

What is the OleDb type I should use when I want to insert say a 40k
piece of text?

Thanks.
 
Follow up to earlier post. It looks like the data is actually in
the database OK at the proper size, and retrieves from the
database properly. The actual problem is that the text is
getting munged/translated. The large string is actualy an
XML serialized DataSet.


DataSet testSet = new DataSet();
testSet = MyDataObjectWork();
testSet.WriteXml("c:\\a.xml" ); // size on disk 14.2 kbytes
testSet.ReadXml("c:\\a.xml");

DataSet insideSet = new DataSet();

string rawData = testSet.Tables[0].Rows[0]["InnerData"].ToString();
int rawLen = rawData.Length; // shows 6.9 kbytes
MemoryStream memoryStream = new MemoryStream();
StreamWriter streamWriter = new StreamWriter( memoryStream );

streamWriter.Write( rawData ); // Exception! Truncated data!

memoryStream.Seek( 0 , SeekOrigin.Begin ); // never get to here or
below
insideSet.ReadXml( memoryStream );
insideSet.WriteXml("c:\\pa.xml");





If I look at the first .WriteXml, I see that there is a lot of

"1" />
<

in there, which means I think I need to translate it to proper <, etc
XML syntax. I think that is my problem. What kind of Encoding should I
wrap this with?

Thanks.
 
Hi xenophon,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you're getting an exception when trying
to write raw data to a MemoryStream. If there is any misunderstanding,
please feel free to let me know.

Based on the code you have provided, I don't think the problem is because
of the encoded signs. I tried writing string full of these signs to a
MemeoryStream, it worked fine on my machine. So for further
troubleshooting, could you let me know what exception and exception message
did you get?

Thanks!

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
The problem was encoding. My solution was to convert the inner-string
to byte[] and from there ReadXml on the stream. That gave me the raw
text that could be converted into a DataSet.

Please close this issue. Thanks.
 
Hi xenophon,

Thanks for sharing your experience with all the people here. If you have
any questions, please feel free to post them in the community.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Back
Top