Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
raven
Forum Newbie
Posts: 3 Joined: Tue Aug 20, 2002 5:56 pm
Post
by raven » Tue Aug 20, 2002 5:56 pm
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
jason
Site Admin
Posts: 1767 Joined: Thu Apr 18, 2002 3:14 pm
Location: Montreal, CA
Contact:
Post
by jason » Tue Aug 20, 2002 6:04 pm
Unless they changed it, the MEMO type fields in Access can only be 255 character's long.
raven
Forum Newbie
Posts: 3 Joined: Tue Aug 20, 2002 5:56 pm
Post
by raven » Tue Aug 20, 2002 6:24 pm
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().
hob_goblin
Forum Regular
Posts: 978 Joined: Sun Apr 28, 2002 9:53 pm
Contact:
Post
by hob_goblin » Tue Aug 20, 2002 6:33 pm
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.
raven
Forum Newbie
Posts: 3 Joined: Tue Aug 20, 2002 5:56 pm
Post
by raven » Wed Aug 21, 2002 8:46 am
If I use
then odbc_result() returns an empty string