Link to home
Start Free TrialLog in
Avatar of crishna1
crishna1Flag for United States of America

asked on

UpperCase/Lower Case


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!

Thanks.
Avatar of gripe
gripe

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?)
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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));
or
Insert into table(column1) values (value);


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
begin
:new.ename := upper(:new.ename);
end;
/

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);

Sujit