Page 1 of 1
Access 2000 Memo Fields
Posted: Tue Aug 20, 2002 5:56 pm
by raven
When I try to retrieve the contents of a memo field from an Access 2000 database, it only returns the first 255 characters.
I've tried using:
but it still only returns 255 characters.
I'm running PHP 4.2.0/Apache 2/Windows XP
Posted: Tue Aug 20, 2002 6:04 pm
by jason
Unless they changed it, the MEMO type fields in Access can only be 255 character's long.
Posted: Tue Aug 20, 2002 6:24 pm
by raven
A Text field can be up to 255.
A Memo field can be up to 64k.
The data is there in full in the database field, I just can't get it using odbc_result().
Posted: Tue Aug 20, 2002 6:33 pm
by hob_goblin
from the manual:
(ODBC SQL types affected: LONG, LONGVARBINARY) The number of bytes returned to PHP is controled by the parameter length. If it is set to 0, Long column data is passed thru to the client.
Posted: Wed Aug 21, 2002 8:46 am
by raven
If I use
then odbc_result() returns an empty string