UpperCase/Lower Case

Posted on 2005-04-21
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

    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 76

    Accepted Solution

    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

    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

    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

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now