Re: PEAR::DB and oracle question

Hi Everyone: On Mon, Dec 08, 2003 at 04:29:05PM +0100, Juan Manuel Caicedo wrote: > > The cause of the bug is that Oracle 'always' returns the keys of an > associative array in upper case, so we will have to make something with > the result of the query. In PHP 4.2 the function array_change_key_case > was introduced and that's exactly the solution that PEAR uses. > > In the class DB_oci8 the function is called in the method fetchInto > (DB/oci.php [version 1.10] lines 194 - 211 ). But notice that the > function will be called only if the attribute $this->options['optimize'] > has the value 'portability'. I notice DB only has the case conversion ability for some database types. Considering the goal is "portability," all database types should have this functionality. This would allow people to develop an application that will run on any supported DBMS without having to code the array_change_key_case() in themselves. Thoughts? --Dan -- FREE scripts that make web and database programming easier http://www.analysisandsolutions.com/software/ T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7th Ave #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409