in reply to Re: Perl Database Select Results Being Truncated
in thread Perl Database Select Results Being Truncated

I'll talk to our database team. I originally wanted a blob type, but they said that they would give me a varchar 1000 to fit my need, but that raises a good point if Perl somehow truncates based on the 255 typical limitation of varchar. The thing that confuses me though is that if 255 is the varchar limit, why the sybase dbase allows it, and allows for me to do a command like select and retrieve the entire entry?

Thanks again for any continued assistance.
  • Comment on Re^2: Perl Database Select Results Being Truncated

Replies are listed 'Best First'.
Re^3: Perl Database Select Results Being Truncated
by Anonymous Monk on Apr 28, 2005 at 17:14 UTC
    Hi again-

    I've tried the LongReadLen, and it still truncates. The database team has said that they kept the type varchar to save space in the database, and that it is possible to go over the 255 character contstraint for the varcar, so I am at a loss why the truncation still happens. Here is a clip of the new code with the LongReadLen attribute set:


    $dbh->{LongReadLen} = 65536;
    $statement = 'SELECT Description FROM DevelopmentTool WHERE ShortName like "%PSP%"';
    $sth = $dbh->prepare($statement);
    $sth->execute;

    while (($Description) = $sth->fetchrow) {

    print $Description . "\n\n";

    }
    Talk soon.
[reply]

In Section Seekers of Perl Wisdom