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

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.
  • Comment on Re^2: Perl Database Select Results Being Truncated

Replies are listed 'Best First'.
Re^3: Perl Database Select Results Being Truncated
by mpeppler (Vicar) on Apr 28, 2005 at 19:08 UTC
    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