Thank you, I read this part of portability and now everything is clear. Thank you.
http://doctrine-dbal.readthedocs.org/en/latest/reference/portability.html 2014-12-17 19:09 GMT-03:00 Benjamin Eberlei <[email protected]>: > > You can use the Portatibility Connection for this: > Doctrine\DBAL\Portability\Connection: > > $connection = DriverManager::getConnection(array('wrapperClass' => > 'Doctrine\DBAL\Portability\Connection', 'portability' => > \octrine\DBAL\Portability\Connection::PORTABILITY_ALL)); > > On Wed, Dec 17, 2014 at 10:51 PM, Pablo <[email protected]> wrote: > >> Staff are implementing the framework doctrine in our application, with >> the intention that it becomes multi-bank. >> >> We started the project with mysql and now to test, try to run with >> postgress and oracle. >> >> What did apparently happens is when postgress brings the data bank, it >> converts the column names to minuscule, as the oracle is on the contrary, >> takes the column names to uppercase. >> >> This brings me a big problem as I recover the data bank accessing the >> spine position each fetch. >> >> Ex (got the internet just for clarity): >> >> <?php >> $connection = $this->getDatabaseConnection(); >> >> $sql = "SELECT Nome >> FROM pessoa >> WHERE id = :id >> AND ativo = '1' >> "; >> >> $stmt = $connection->prepare($sql); >> $stmt->bindValue("id", $id); >> $stmt->execute(); >> $resultado = $stmt->fetchAll();?> >> >> >> When Postgress use the $result array is: >> >> Array( >> [0] => Array >> ( >> [nome] => pablo >> )) >> >> >> When using the Oracle $result array is: >> >> Array( >> [0] => Array >> ( >> [NOME] => pablo >> )) >> >> >> When I use the MySQL $result array is: >> >> Array( >> [0] => Array >> ( >> [Nome] => pablo >> )) >> >> >> So in my application there was something like: >> >> echo $ result ['name']; >> >> This works only for MySQL as the key to postgress is lowercase and >> uppercase is oracle. >> >> I have not found an elegant way to solve this problem. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "doctrine-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/doctrine-user. >> For more options, visit https://groups.google.com/d/optout. >> > -- > You received this message because you are subscribed to the Google Groups > "doctrine-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/doctrine-user. > For more options, visit https://groups.google.com/d/optout. > -- Pablo Vanni -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
