Re: PEAR::DB and oracle question

From: Date: Mon, 08 Dec 2003 19:15:04 +0000
Subject: Re: PEAR::DB and oracle question
References: 1  Groups: php.pear.dev 
Request: Send a blank email to pear-dev+get-24294@lists.php.net to get a copy of this message
Arnaud Limbourg wrote:
Hello all, A bug concerning liveuser http://pear.php.net/bugs/bug.php?id=355 brings to ask a question to any PEAR::DB oracle user out there. Apparently when a query is made against an oracle database oracle send backs the fields name upper cased. Even though an alias is passed in the query like SELECT myField AS myfield the 'myfield' is returned as 'MYFIELD'. Since i don't have access to an oracle database, can anybody confirm this and does anybody know how to overcome this ? Arnaud.
All oracle queries return the columns as upper case, this is in any language, it's part of the Oracle server. You should always expect the field names to be in upper case, unfortunately. I recommend writing your queries with upper case tables/fields because that's how it comes back. -- paperCrane <Justin Patrin>

« previous php.pear.dev (#24294) next »