the way I do it is with http://www.ytztech.com product SQL_AL.PHP which
has a switch that will say all values are upper or lower. You can also
create a simple wrapper function that will do the lower conversion.
From: William Cheung [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 2:27 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Oracle and upper case field name
When Oracle returns the result set, the field names are all in upper
case. However, I have an application that needs to work on both MSSQL
and Oracle. I don't want to keep 2 copies. One has upper case field
names and the other lower case. How could I make PHP or ADODB to work
with lower case field names even the result set is upper case?
William Cheung <mailto:[EMAIL PROTECTED]> B.Sc, MCSE, MCDBA
Databyte Corp. <http://www.databyte.com/>
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.567 / Virus Database: 358 - Release Date: 1/24/2004