Subject Re: [firebird-php] Re: php case insensitive field access
Author Lester Caine
jackdmason wrote:
> Who maintains the Firebird PHP interface? That is where this problem needs to be resolved with either better documentation or implementation of a missing Firebird capability.
The original author is no longer around, but did a great job with building the
version of php_interbase shipped since PHP5.0. Marius has added a few small
fixes to it in recent times, but apart from breaks introduced by API changes in
earlier versions of PHP5 there has been little need to change anything.
pdo_firebird is something we tend to avoid although it is functional.

> MySQL performs a case-insensitive search when you use LIKE. Even if the PHP interface allowed that, it would solve the problem.
The Firebird version of LIKE is case sensitive. It's not the interface that
affects that fact. You need to use the 'COLLATE' trick to make it work, however
the one we forgot to mention is 'CONTAINING' which will find the string anywhere
in the field, but is case insensitive.

I'd still like to know what PHP code you are using to access Firebird. It does
have a bearing on what works. I've used ADOdb since the start of switching to
PHP and this handles everything I need.

Lester Caine - G8HFL
Contact -
L.S.Caine Electronic Services -
EnquirySolve -
Model Engineers Digital Workshop -
Rainbow Digital Media -