the way I do it is with 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.
- Paul

-----Original Message-----
From: William Cheung [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 27, 2004 2:27 PM
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. <>  


Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.567 / Virus Database: 358 - Release Date: 1/24/2004

Reply via email to