Re: DBI/ODBC Truncating Long Fields

I am having problems with my ODBC call truncating Long fields that are 4000+ characters long

Have you looked at the DBD::ODBC POD? The Frequently Asked Questions section says:

How do I read more than N characters from a Memo | BLOB | LONG field?
See LongReadLen in the DBI docs.
Example:
 $dbh->{LongReadLen} = 20000;  
 $sth = $dbh->prepare(``select long_col from big_table'');  
 $sth->execute;  
 etc
[download]

Comment on Re: DBI/ODBC Truncating Long Fields Download Code

Replies are listed 'Best First'.
Re: Re: DBI/ODBC Truncating Long Fields by LostS (Friar) on Jan 23, 2003 at 01:12 UTC
You RULE... and no I was looking at the DBI Man page... THANK YOU.... ----------------------- Billy S. Slinar Hardtail - Hand of Dane Datal Ephialtes - Guildless RallosZek.Net Admin/WebMaster `perl -e '$cat = "cat"; if ($cat =~ /\143\x61\x74/) { print "Its a cat! +\n"; } else { print "Thats a dog\n"; } print "\n";'` [download]	[reply] [d/l]
Re: Re: Re: DBI/ODBC Truncating Long Fields by bart (Canon) on Jan 23, 2003 at 01:16 UTC
Hmm... the DBI docs do mention "LongReadLen" too. "LongReadLen" (unsigned integer, inherited) This attribute may be used to control the maximum length of long fields ("blob", "memo", etc.) which the driver will read from the database automatically when it fetches each row of data. The "LongReadLen" attribute only relates to fetching and reading long values; it is not involved in inserting or updating them.	[reply]