ADO.Net - Sybase 11 - getting contents of TEXT field from a DataSet into a String

  • Thread starter Thread starter Bryan Donaldson
  • Start date Start date
B

Bryan Donaldson

Situation - ASP.Net application using VB.Net connecting to Sybase 11
database using Sybase ASE OLEDB provider

I've got a DataSet being returned that contains one table (actually a view
whose definition contains several joins). That table contains a few
columns which in Sybase are defined as TEXT.

When I view the contents of the DataRow returned from the query, the TEXT
fields contain "trash". What are the gyrations I need to go through to get
the real contents of the TEXT fields?

(As far as I can tell - the contents are not Unicode - the code points when
I look at them are not valid for the text that I can see is in the field
from the source application.)
 
Hi Bryan,

Basically you should not do anything. When you retrieve data from the
database, you DataSet should get just plain text. I think it could be some
sort of provider's issue. Did you try to find something on a Sybase site?
Which version of Sybase server are you using? I will try to reproduce it on
my server as well
 
Back
Top