[mdb-dev] SEGV with > 255 character MEMO fields in PHP/ODBC

[Mike P. <mj...@fi...>]

Hi all,

Just getting my head around mdb-tools, and I thought I'd throw this out 
in case it sparks an 'ah-ha' with someone more familiar with the code.

In the nutshell, I've got a JET3 mdb which works fine querying via 
mdb-sql... however, using PHP and UnixODBC, I get a segfault running a 
select query that retrieves a memo field with more than 255 characters 
in it.

I'm guessing that perhaps some part of the code is reporting a smaller 
size for this field than is being allocated, but at a cursory 
inspection, the whole mechanism for field lengths looks as if it needs 
more than a cursory inspection!

The GDB backtrace doesn't help much as it's not in the mdb-tools code!

(gdb) bt
#0  0x081724e3 in zend_hash_find ()
#1  0x081791fd in zend_assign_to_variable_reference ()
#2  0x0817ddce in execute ()
#3  0x0816d9d9 in zend_execute_scripts ()
#4  0x0814522d in php_execute_script ()
#5  0x08180acf in main ()

I'll keep on digging, but if anyone has any ideas....

Fedora Core 2
PHP 4.3.10
Unix ODBC 2.2.8
CVS version of mdb-tools

As an aside, I've also coded up queries for date comparisons in 
sargs.cm, and return of GUID fields and equality comparison - is this 
worth submitting in, or have other people been working on this ?