[Last Call] Learn how to a build a cloud-first strategyRegister Now


UpperCase/Lower Case

Posted on 2005-04-21
Medium Priority
Last Modified: 2007-11-27

We have an application , which has few drop downs on a screen.

The values in the drop down are in lower case, when i pick them and save they gets saved in UPPERCASE.

When this database has been loaded on a diffrent server , perform the same operation , the record get ssaved to the database as it appears in the drop down.

the question is , hwo is thei happening? is ther a setting on the database server where i can say "save everything in upper case" or waht?

FYI: This is an Oracle database.

Please let me know!

Question by:crishna1
LVL 13

Expert Comment

ID: 13837338
Some questions:

What data type is the column you're saving to?
What language are you using to save the data?
How are you saving the data? (Code example?)
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 13837382
I typically create a trigger for lookup tables that convert items inserted in a consistant way.  I'm betting the UPPERCASE DB has a before insert trigger on that table.  Check out the view:  user_triggers.
LVL 14

Expert Comment

by:Muhammad Ahmad Imran
ID: 13839611
My Question is here. Are you using two diffent copies of application or the application is replicated.Look
1. If you use exactly same copy of applications over two sites t hen it si probabilly on the server side.
2. In the situtation you provied I believe that the it is change in application code.

At one site it is happening.

Insert into table(column1) values (upper(value));

and 2nd site it is:
Insert into table(column1) values (lower(value));
Insert into table(column1) values (value);

LVL 11

Expert Comment

ID: 13841527
I think there was a trigger in your DB previously for converting the column values into UPPER CASE. The trigger can be made here. For a example, for converting ENAME (Employee Name) column to upper case in EMP table the trigger will be,

create or replace trigger trg_upper_emp_ename before insert or update of ename on emp for each row
:new.ename := upper(:new.ename);

You can create a trigger like this in your DB. Also update all the existing values of the column in the DB.
update emp set ename = UPPER(ename);


Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses
Course of the Month18 days, 6 hours left to enroll

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question