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:

Code: Select all

odbc_longreadlen($result, 16384);
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

Code: Select all

odbc_longreadlen($result, 0);
then odbc_result() returns an empty string