problem of case-sensitvity while retrieving columns from oracle 10g

[bhakti_thakkar]

hi all,
i m using oracle 10g for my php - pear application. the problem is, the table names, column names are multi - cased e.g Investors_T , Investor_ID etc. but while retrieving the columns, oracle returns tablenames as well as columns names in upper case. while writing the php fetch query, i have written the field names in the way i have defined while creating the tables. how can i eliminate this problem.


Thanks in advance

[shyam]

table/column names are case-insensitive in oracle only the data is case-sensitive

[bhakti_thakkar]

hi

table/column names are case-insensitive in oracle only the data is case-sensitive

try out once the data retrival using php + pear + oracle10g. things will be clear to you. i am taking about the fetch in php script. pear retrives it in uppercase irrespective of multi-case in my DB. so how can i eleminate this, without changing my php script...:confused: .
i think the problem is with pear and php. not with oracle as i am facing the output problem with my php, pear script. i have to type the query in PHP this way:

$sql=' select "Contact_ID" from "Contact_T" where "Contact_ID" = '."'".$Contact_ID."'"."'";

which other wise i would write as below:

$sql="select Contact_ID from Contact_T where Contact_ID= '$Contact_ID' ";



But thanks for your reply