Subject Re: [firebird-php] Re: [Firebird-general] Software Port Info
Author Lester Caine
Philippe Makowski wrote:

> Le 15/09/2006 11:18, Paul Reeves a dit :
>
>>On Friday 15 September 2006 09:26, Philippe Makowski wrote:
>>
>>>It seems that adodb need some patch, does anyone of the Php users can
>>>take it in charge ?
>>
>>Is there any reason why the original author cannot submit his patch to the
>>maintainer of adodb?

> I don't know
> the patch is not very large
> script modification in
> /adodb/drivers/adodb-ibase.inc.php
>
> // First modification
> // var $fmtTimeStamp = "'Y-m-d, H:i:s'";
> var $fmtTimeStamp = "'Y-m-d H:i:s'";
THAT should be part of the project setup for ADOdb, changing it will
cause other projects problems.

> // Second modification
> // var $metaColumnsSQL = "select a.rdb\$field_name,
> var $metaColumnsSQL = "select lower(a.rdb\$field_name),
We have standardised on UPPER rather than lower. LOWER is not available
as standard in Firebird 1.5. ADOdb is told to return 'lower' format
names if you need to!

> perhaps Lester have contact with adodb team ?
>
> and perhaps the better place for this is : adodb-firebird.inc.php

These are changes that are project dependent. We do not use the raw
ADOdb with bitweaver having a modified version that ties in with the
standards that bitweaver uses. Since there is not a 'standard' to work
to, every project is different :(

The other comment I would make is that PHP4 is *NOT* the version of PHP
to be using with Firebird as it's driver does not have many of the
extras that make Firebird work best. bitweaver/ADOdb will not actually
run with the PHP4 php_interbase, only the current PHP5 version.

--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -
http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php