Kanji
User
/ Moderator
May 12, 2002, 4:02 PM
Post #2 of 2
(2636 views)
|
|
Re: [emily] SELECTING a long string from a DB
[In reply to]
|
Can't Post
|
|
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.
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(
'dbi:ODBC:database',
'user',
'password',
{
LongReadLen => 65_536, # 1 + max possible memo size
LongTruncOk => 1, # Shouldn't be necessary
},
); |
MAIN
SEARCH
WHO'S 
LOG 