[Pdx-pm] $dbh->{LongReadLen}

[Stephen Wickman]

Setting a static value of $dbh->{LongReadLen}=2000000000 sends perl to a dark place so I have to drop it to max needed. Turns out I accidentally placed the dynamic allocation within the fetch loop so I'm not sure what size was actually in play per fetch. Setting the size needed per statement before the prepare did the trick.

[FROM] Jeff Zucker [DATE] 2007-05-31 04:34 P:
> $dbh->{LongReadLen} = 2000000001; ? :-)
> 
> Stephen Wickman wrote:
>> Anyone know the fuzzy math to capture the data in long varchar
>> 2000000000 column?
>> Setting $dbh->{LongReadLen} = $dbh->selectrow_array(qq(select
>> length(col) from tbl)) doesn't quite suffice. Per "Programming the
>> DBI", there is some addl overhead, but I'd prefer numbers in lieu of
>> "slightly more than the length of the longest column".
>> --thx, Steve
>> _______________________________________________
>> Pdx-pm-list mailing list
>> Pdx-pm-list at pm.org
>> http://mail.pm.org/mailman/listinfo/pdx-pm-list
>>
>>
>>   
> 
>