Administer > Database administration > Case-Sensitivity

Case-Sensitivity

Service Manager works with both case-sensitive and case-insensitive databases, enabling you to set things up the way that best meets your needs. Your users will be able to search for data case-sensitively or insensitively, as you choose. To achieve this, all servers and clients must be set to the same sensitivity.

Service Manager supports both case-sensitive and case-insensitive databases. You can configure the case-sensitivity of your database when you set it up. For more information, refer to Service Manager Installation.

  • Prior to converting a system to be case-insensitive, you must first ensure that your RDBMS supports case-insensitivity.
  • We recommend implementing case-insensitive searching on a test system prior to setting it up on your production system.

Related topics

JavaScript/RAD implications of a case-insensitive database environment
Load/unload implications of case-sensitivity
Oracle case-sensitivity
Prepare your RDBMS