in reply to Re: DBI::Sybase -retrieving BLOB values from ms-sql question
in thread DBI::Sybase -retrieving BLOB values from ms-sql question

yeah i read through the dbd::sybase and have tried setting LongReadLen to really big values (like 80000,8000,4000) and a small one (1) but they all do not seem to affect the output.Sigh:(
  • Comment on Re^2: DBI::Sybase -retrieving BLOB values from ms-sql question

Replies are listed 'Best First'.
Re^3: DBI::Sybase -retrieving BLOB values from ms-sql question
by anexiole (Novice) on Jul 10, 2006 at 04:09 UTC
    guys!!
    thank you for your help!
    I solved the issue!
    I shouldn;t have used the SUBSTRING function within the SQL!!
    my previous Sql read :

    SELECT IssueNo , SUBSTRING(IssueText,0,DATALENGTH(IssueText)+1) AS IssueText
    FROM Issues
    WHERE AccountNo = 'account-number' AND IssueNo = 'issue-number' ORDER BY IssueNO ASC