Case sensitive issues.

[pascal01]

We have a application written in Java and running on an Oracle 10g database.
In the application, we have a search column which is case sensative. You must enter the exact spelling and case in order to find a match. I want to be able to search in any case and find a match. How can I remove the case sensative problem ? Is there a dba parameter than I can set ? Thank you.

[gandolf989]

There is, but you might find it easier to either change the case of what you are storing using an insert/update trigger, or you can create a function based index on either the upper() or lower() functions. You would then search with the upper() or lower() functions being applied to the search criteria. For me if the column was a username, email or code I would just use a trigger to force everything to be lower case. Then I would use lower() to make sure that the search criteria is lower case. If it is a name I might use initcap to force proper capitalization for names.