DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2001

    Question Case sensitive issues.

    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.

  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    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.
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.