Are Database Lookup fields case sensitive when using an Oracle 11g Database?
14912
QAID # 14912 Published
Question / Problem:
Are Database Lookup fields case sensitive when using an Oracle 11g Database?
Answer / Solution:
Database Lookups are not case sensitive, but when using Oracle 11g as a database, there is asetting that needs to be set with Oracle:
- Access the Oracle Configuration Manager.
- Click the "DB Options" menu at the top of the window and then click on "Case".
- Click "Disable Case Sensitivity".
Applies to:
| Product | Version | Category |
|---|---|---|
| AXPRO | 5.0 | Validation |