This is really simple. I am querying a MS-SQL Server table that has TEXT in its blob field.It stores descriptions.
When i run an sql such as below from Microsoft Enterprise console, 
"                              SELECT IssueNo , SUBSTRING(IssueDescrip
+tion,0,DATALENGTH(IssueDescription)+1) AS IssueText
                                FROM Issues
                                WHERE     AccountNo = '1036'
                                ORDER BY IssueNO ASC "

[download]
it returns the blob value stored in "IssueText" in completeness but when i ran the PERL script to get it, the dump out showed the value with a length of 255 characters! This is utterly strange as I have read around online and have tried using differt ways of querying (ie such as syb_ct_get_data) and can't get anywhere...

At the moment,here is how I do the query : 
                        $stmt =             $source_dbh->prepare($self
+->get_T3_issue_ids_sql($T3_account_id));
                        $status = $stmt->execute();
                        if ($status)
                        {
                                $res = $stmt->fetchall_hashref('IssueT
+ext');
                        }
                        debug(20,qq|Sql to get_issues for account,$T3_
+account_id : \"|.$self->get_T3_issue_ids_sql($T3_account_id).qq|\"\n|
+);

                        #debug more...
                        foreach my $elem(%{$res})
                        {
                                if (defined($res->{$elem}->{'IssueText
+'}))
                                {
                                        debug (20,qq|$res->{$elem}->{'
+IssueNo'}:Current IssueText-\"|.$res->{$elem}->{'IssueText'}.qq|\"\n|
+);
                                }
                        }

[download]
Very sorry to trouble you guys but I really need your help.
thank you in advance.


Gordon,
anexiole@gmail.com

20060707 Janitored by Corion: Changed PRE tags into code tags, as per Writeup Formatting Tips

In reply to DBI::Sybase -retrieving BLOB values from ms-sql question by anexiole

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.