May 12, 2002, 4:02 PM
Post #2 of 2
There is an upper limit of 255 characters for text fields and 65,535 characters for memo fields, but both are on the Access side and both are much higher than the 80 you're trying to SELECT.
Re: [emily] SELECTING a long string from a DB
[In reply to]
However, you don't elaborate on exactly what trouble you're having (error messages are useful ;^), but from previous experience with memo fields, you might have luck with the LongReadLen and LongTruncOk attributes in your DBI->connect...
my $dbh = DBI->connect(
LongReadLen => 65_536, # 1 + max possible memo size
LongTruncOk => 1, # Shouldn't be necessary