only 255 char long data is retrived using perl5 from database as syabse 12.5

pooja · #1 (**permalink**) 06-04-04, 11:09

Hello All,

I am quite new to Perl.Problem i am facing is When i try to retrive some value from database(Sybase12.5) using perl5 it retrives me value of 255 length although i have 400 char long data in the column .
Can anyone please tell me the reason behind it.

thanx in advance
Pooja

senza_nome · #2 (**permalink**) 06-18-04, 22:56

Hi,

Look up "LongReadLen" attribute: as in

$o_dbh{PPSY2K}=DBI->connect("DBI:ODBC:database","user","password",{Au toCommit => 0, LongReadLen=> (4*1024-1)*1024}) or die "Can't connect: $DBI::errstr\n";

Hope it helps!

pooja · #3 (**permalink**) 06-21-04, 00:21

Hi!,
thanx for ur response.

I am not setting anything as length, so default would be used i guess.

Moreover i have found that with Sybase 12.5 sybperl version 2.15 is needed.(in order to support increased column length).

--Pooja

senza_nome · #4 (**permalink**) 06-21-04, 01:02

See pages 141-142, 151-152 of Alligator Descartes & Tim Bunce's Programming the Perl DBI