OleDb text Blob Truncating
Ray Norrish
I'm using a Sybase 7.04 db provider name ASAProv.70, and OleDb connection
and I've got an issue with a Text Blob field not returning a value on a
select statement if the field contents is over 198 characters long.
I've been researching this issue for a while to no avail.
I have the connection set up through ODBC, originally I was using ODBC
providers through ADO.Net but due to slow database response times (waiting
over a minute to return 10000 records) I've had to move to OleDb which
returns the 10000 records in a second. The only down fall is that my blob
text data type fields no longer return a value (return blank), I've tried a
variety of things to solve the issue and have so far found out that if the
text field contains 198 characters or less then the data is returned, else I
get blank.
I can happily update the field with text but not return the value.
I've looked into text field truncation and found a blog in which the writer
set 'Text Size=100000' or some value, into the connectionString parameters.
This hasn't worked. I've tried changing the column datatype to varchar(255)
and this didn't solve the problem, which is strange. The text field is
selected by name in my select statement (through a stored proc) and is the
last column in the select list (which in this case only has two columns: an
id column and the text blob column).
Any suggestions guys.
Hugh