Welcome Guest, Not a member yet? Register   Sign In
Oracle and the upper case field
#1

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


Messages In This Thread
Oracle and the upper case field - by El Forum - 11-10-2009, 08:45 PM
Oracle and the upper case field - by El Forum - 07-20-2010, 08:43 AM
Oracle and the upper case field - by El Forum - 07-20-2010, 11:02 AM
Oracle and the upper case field - by El Forum - 07-20-2010, 01:48 PM



Theme © iAndrew 2016 - Forum software by © MyBB