Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Posts
    104

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

    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

  2. #2
    Join Date
    Jun 2004
    Location
    Nowhere Near You
    Posts
    89

    LongReadLen

    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!

  3. #3
    Join Date
    Dec 2002
    Posts
    104
    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

  4. #4
    Join Date
    Jun 2004
    Location
    Nowhere Near You
    Posts
    89

    Programming the Perl DBI

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •