ZF2-277: Oracle DB tables and columns names are case sensitive

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

  • Oracle

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:

Have you found an issue?

See the Overview section for more details.


© 2006-2018 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.