You don't show any code, so I'm going to take a guess.

If you're using the DBI, check the docs for LongReadLen. Here's an example. It gets the data from an Access db using ODBC instead of ADO. Several fields have a lenth of 1500.

my $datasource = 
"driver=Microsoft Access Driver (*.mdb);dbq=c:\\s\\database.mdb";
my $username = 'admin';
my $password = '';
my $dbh = DBI->connect( "dbi:ODBC:$datasource", $username, $password,
                        { LongReadLen => 1500, RaiseError => 1 })
                || die "Error connecting: $!";
[download]

HTH