PHP GENERAL 4 OCI ASSOC RETURNS KEY WITH UPPER CASE STRING
Date: Fri, 4 Jul 2003 19:38:30 -0400

Subject: OCI_ASSOC returns key with upper case string
From: reubendb@no-spam (Reuben D. Budiardja)

Hello,
First let me say that I am not sure if this is PHP problem or Oracle.=20

I have a class that contains API for using postgresql, mysql, or oracle=20
database so switching database should be "in theory" just changing an=20
argument for me.=20
To make this sort, let just say that the return of a SELECT statement is=20
always in associative array, using either :
"pg_fetch_assoc" for pgsql "mysql_fetch_assoc" for mysql "ocifetchinto" with OCI_ASSOC flag for Oracle 9

Now, pg_fetch_assoc and mysql_fetch_assoc return the associate array with=
the=20
key in lower case. But ocifetchinto returns the key in UPPER case. So thi=
s=20
discrepancy makes my code not as portable as I would like it.=20
Furthermore, the example here:
http://us2.php.net/manual/en/function.ocifetchinto.php
doesn't even work, because it uses lower case as the associative array ke=
y.

Why is this the case? Is this PHP problem or Oracle config problem? Eithe=
r=20
way, can anyone suggest a solutions? Of course I can do all kind of array=
=20
manipulation in my API to make the key lower case, but that wouldn't be v=
ery=20
elegant and efficient
Thanks in advance for any help.
RDB --=20
-------------------------------------------------
/"\ ASCII Ribbon Campaign against HTML \ / email and proprietary format X attachments.
/ \
-------------------------------------------------
Have you been used by Microsoft today?
Choose your life. Choose freedom.
Choose LINUX.
-------------------------------------------------