in reply to DBI::Sybase -retrieving BLOB values from ms-sql question
Since nobody else has answered your question, I'll take a shot at it...
My guess is that a "blob" in ms-sql has an internal length of 255, and somehow your "Microsoft Enterprise console" is simply reformatting it, to remove extra spaces.
You haven't shown what your output looks like, so it's hard to be sure, but if that is what's happening, how about just doing the same thing in Perl? Try something like the following:
foreach my $elem(%{$res}) { if (defined($res->{$elem}->{'IssueText'})) { my $result = $res->{$elem}->{'IssueNo'}; $result =~ s/\s+$//; # Delete trailing whitespace debug (20,"$result:Current IssueText-\"$result\"\n|); } }
(Note that I've cleaned up the multiply-concatenated qq syntax which made things a bit more difficult to read).
Does that give you something more like what you're getting with "Microsoft Enterprise console"?
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: DBI::Sybase -retrieving BLOB values from ms-sql question
by anexiole (Novice) on Jul 07, 2006 at 22:41 UTC | |
by Anonymous Monk on Jul 10, 2006 at 02:19 UTC |