Case sensitive issues.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Case sensitive issues.

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218

    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
    Location
    Pittsburgh, PA
    Posts
    4,026
    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