Re^3: Unable to retrieve field which has more than 255 chars

I am not sure for DBI:Sybase, but there could be some trouble with 255 characters.

1. driver and other version problem(TDS? I found http://comments.gmane.org/gmane.comp.db.tds.freetds/7075
2. explicit bind_param http://www.perlmonks.org/?node_id=491253
3. DBI's LongReadLen http://search.cpan.org/~timb/DBI-1.618/DBI.pm#LongReadLen

I tested to fetch long field with MS Access's memo field (DBI::ADO). 1000byte. I thought I see the same trouble once before with MS Access(may that be a dream of mine?). But it returns long field fine on windows without explicit bind_param nor setting LongReadLen... It was just fine.

I forget where I saw the same situation. Sorry for uncertain information.

Comment on Re^3: Unable to retrieve field which has more than 255 chars

Replies are listed 'Best First'.
Re^4: Unable to retrieve field which has more than 255 chars by Anonymous Monk on Mar 07, 2012 at 12:40 UTC
Thank you remiah... I referred the link and it got fixed. I already had entry in freetds.conf file and it had version 8. I simply removed the port=1433 in connection and it worked... ! Baffling, really; how this change had effect in truncation... Anyhow, it fixed my issue. Thanks for all your replies	[reply]