in reply to Perl Database Select Results Being Truncated

Which database is this, and what perl module/client are you using?

Michael

  • Comment on Re: Perl Database Select Results Being Truncated

Replies are listed 'Best First'.
Re^2: Perl Database Select Results Being Truncated
by Anonymous Monk on Apr 28, 2005 at 16:00 UTC
    I am using a Sybase database, and the Perl DBI module.

    I even tried to write a simple, non-CGI version of the script, where the perl code only does the select on the trouble column, and print to the command line...same results.
      Ah.

      Then please make sure that you have Sybase 12.5 Client Libraries installed, and that your DBD::Sybase module is recent (1.04 or later), and that it was built with the 12.5 libraries.

      Otherwise the client side of the connection tells the server side that it doesn't know about "wide" varchar columns, and you get the 255 char truncation.

      Michael