how to set lower field name on Oracle 9i when fetching data using ASSOC Type

[ahmadmunif]

i'm using sql plus to create table.
i defined field name in lower case.
if i describe table, field name showing in UPPER CASE.

i'm using OCIFetchInto and set OCI_ASSOC flag,to get array data.
i have to set UPPER CASE to field name to get data.
like this variable : $array_data["UPPER_CASE"];

how to set field name in lower case, i don't know
how to set it when create table or fetch record ?.

thanks

[[deleted]]

How about strtolower($array_data["UPPER_CASE"]
);

[ahmadmunif]

i fomerly using postgresql or mysql database. i naver get a problem to fetch data (using assoc type).

becouse of php function that fetch data like pg_fetch_array produce assosiative array with lower case . like this one :
array("lower_field_name"=>"value"))
so i can fetch data : $data["lower_field_name"].

but if i used oracle function to fetch array data, OCIFetchInto produce array data with UPPER CASE FIELD_NAME :
array("UPPER_FIELD_NAME"=>"value").

i define table field name with lower case,
so i want to get field name in lower case
too.

why oracle function set it to UPPER CASE ?.
any one can help me how to set it to
lower case field name, what options ?

i just want to see filed name like what i've defined. if i define filed in lower case, i can fetch array data in lower case .

thanks

[[deleted]]

"why oracle function set it to UPPER CASE ?. "

that's oracle's way, they just do it...

you could write a routine that copies all the data from the uppercase keys to the lowercase ones, but that takes a lot of resources.