The fifth column being the "large column". I am assuming a perl array doesn't like elements with that much data in it. I can't reduce the amount of data, does anyone have any ideas?

Perl doesn't care. The ODBC driver is complaining, not Perl. 500 chars is not at all large or anywhere near large, by the way.

The very first hit Google gives me when I search for String data, right truncated on column number is:
http://www.easysoft.com/products/9999/faq_answer.phtml?ID=716&product=2002. It contains a detailed explanation of the problem and mentions a very easy work around for Perl users

Next time, STFW before asking.

Juerd
- http://juerd.nl/
- spamcollector_perlmonks@juerd.nl (do not use).