Oracle DB tables and columns names are case sensitive #2473

Closed
zfbot opened this Issue Sep 28, 2012 · 6 comments

Comments

Projects
None yet
3 participants

zfbot commented Sep 28, 2012

Jira Information

Original Issue:ZF2-277
Issue Type:Bug
Reporter:ZeinEddin
Created:04/25/12
Assignee:ralphschindler
Components:Zend\Db

Description

The name of tables, columns... when using oracle DB with PDO (Table gateway) are case sensitive, it must be case insensitive.

zfbot commented Sep 28, 2012

(Originally posted by: ZeinEddin on 04/26/12)

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

zfbot commented Sep 28, 2012

(Originally posted by: ralphschindler on 05/08/12)

Why wouldn't you use the correct casing for the table and column names?

zfbot commented Sep 28, 2012

(Originally posted by: ZeinEddin on 05/08/12)

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?

zfbot commented Sep 28, 2012

This issue was ported from the ZF2 Jira Issue Tracker at
http://framework.zend.com/issues/browse/ZF2-277

Known GitHub users mentioned in the original message or comment:
@ZeinEddin, @ralphschindler

@ghost ghost assigned ralphschindler Sep 28, 2012

Awnage commented Dec 5, 2012

Would be great if the pdo_oci driver was as well maintained as other drivers. Until then I think we are left only with the oci8 driver which leaves us Oracle users out in the cold with respect to ORM layers and most of the frameworks out there.

Member

ralphschindler commented Jan 25, 2013

Please see: #3485 & #3567

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment