Home » SQL & PL/SQL » SQL & PL/SQL » Case Sensitivity
Case Sensitivity [message #365167] Fri, 16 June 2000 23:22 Go to next message
S. Alexander
Messages: 2
Registered: June 2000
Junior Member
Can an Oracle database be set case insensitive? Using Web Logic, does case(i.e., toUpper or toLower) need to be set in the session bean? Trying to work through an issue where the beans are complete, but case sensitivity not addressed. I have user interfaces, with search functions. I'm afraid that they will not be able to find data without having the exact case match. Do I need to update all of the beans? I was in a SQL Server environment where case did not matter. Now moving to Oracle8. Any suggestions?
Re: Case Sensitivity [message #365174 is a reply to message #365167] Wed, 21 June 2000 13:56 Go to previous message
Frank Naude
Messages: 4569
Registered: April 1998
Senior Member
Hi,

Try to write PL/SQL or Java database triggers on you tables to update incomming values to UPPER().

Hope it helps.

Cheers
Frank
Previous Topic: Convert number to string
Next Topic: Selecting data from nested tables
Goto Forum:
  


Current Time: Mon Jun 21 20:20:26 CDT 2021