Re: [PHP-DEV] Bug in ODBC module From: Rasmus Lerdorf (rasmus <email protected>)
Date: 06/11/98

> a) I checked out the source code. Where str.val is assigned empty_string
> str.len is NOT set to 0. It has to be set!!! So please whoever is in
> charge of the module, go through it and fix this.

Ouch.

> b) The most important problem. When retreiving a memo field it ALWAYS has
> the number 1 appended to it. For example if I have a memo in MS Access
> "Today you need to buy fruit" and I print it from PHP I get "Today you
> need to buy fruit1". This doesn't happen when I change it's type to plain
> text. So it's probably some bug.

Sounds like an off-by-one bug where the null is written to the wrong place
or str.len is off by one.

I don't know this code at all either and can't really test it here, but if
nobody else is going to dive into it, I will. It would be good if Shane,
Andreas or Stig could take a look here since they have ODBC setups they
can test on.

-Rasmus