Issue Type: Bug Created: 2012-04-25T12:21:03.000+0000 Last Updated: 2012-10-08T20:15:20.000+0000 Status: Closed Fix version(s): Reporter: Mohammad A. ZeinEddin (m_zeineddin) Assignee: Ralph Schindler (ralph) Tags: - Zend\Db
Related issues: Attachments:
The name of tables, columns... when using oracle DB with PDO (Table gateway) are case sensitive, it must be case insensitive.
Posted by Mohammad A. ZeinEddin (m_zeineddin) on 2012-04-26T13:20:43.000+0000
I think that the only thing that have to be done is to provide a parameter so that the names of the columns and tables will not be quoted, for example: SELECT * FROM "FND"."PERSONS" WHERE "ID" = :where1 with the quote parameter set to false must be: SELECT * FROM FND.PERSONS WHERE ID = :where1
Posted by Ralph Schindler (ralph) on 2012-05-08T21:35:09.000+0000
Why wouldn't you use the correct casing for the table and column names?
Posted by Mohammad A. ZeinEddin (m_zeineddin) on 2012-05-08T21:54:56.000+0000
Actually: there is no reason, it is just we used to write all of identifiers names in a lower case. is there any issue in providing a parameter that will disable quoting identifiers? and another question I don't know if this is the right place to ask: what is the status of the oracle adapter class? we are considering to start a BIG new project backed with oracle DB, and I think that we will use ZF2 , but it still has no support for oracle, right? when will it be ready?
Posted by Ralph Schindler (ralph) on 2012-10-08T20:15:20.000+0000
This issue has been closed on Jira and moved to GitHub for issue tracking. To continue following the resolution of this issues, please visit: https://github.com/zendframework/zf2/issues/2473
Have you found an issue?
See the Overview section for more details.