Oracle and the upper case field

[eluser]Unknown[/eluser]
i am working with php 5 and oracle 10g. i have migrated my database from mysql to oracle. but i got the problem when i select the data from oracle which is return in uppercase.
eg:

Code:

$dbObj->STAFF_NAME

how do i convert it to lower case like this

Code:

$dbObj->staff_name

becoz before i migrate to oracle, my code run properly with mysql result set. but after i done the migration from mysql to oracle i need to change my active to UPPERCASE.
i dont want to change my code. a lot of work has to be.

anyone can give me some suggesstion to trouble shoot my proble.

[eluser]fszostak[/eluser]
I have same problem.

Exist any configuration to change for lowercase?

[eluser]fszostak[/eluser]
[quote author="fszostak" date="1279655001"]I have same problem.

Exist any configuration to change for lowercase?[/quote]

I solved changing table creation, select option "preverse lowercase/uppercase".

[eluser]KingSkippus[/eluser]
This is why I hate databases and languages that aren't case-sensitive.

Have you tried modifying your query to specify the column name in lower-case? For example:

Code:

SELECT
  EMPLOYEE_ID "employee_id",
  FIRST_NAME "first_name",
  LAST_NAME "last_name",
  /* ... */
FROM
  EMPLOYEES