Oracle and the upper case field

Oracle and the upper case field - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Oracle and the upper case field (/showthread.php?tid=24470)

Oracle and the upper case field - El Forum - 11-10-2009

[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.

Oracle and the upper case field - El Forum - 07-20-2010

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

Exist any configuration to change for lowercase?

Oracle and the upper case field - El Forum - 07-20-2010

[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".

Oracle and the upper case field - El Forum - 07-20-2010

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

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