A. Command Reference : General Command Syntax : Delimited Identifiers and Case Sensitivity
 
Share this page                  
Delimited Identifiers and Case Sensitivity
By default, identifiers are forced to lowercase, and are therefore case-insensitive. The casing rules can be specified at installation time for delimited identifiers. The following settings are allowed:
Ingres setting: lowercase (case-insensitive; forces all letters to lowercase).
ISO Entry SQL-92 standard: mixed case (case-sensitive; preserves case for delimited identifiers); regular identifiers are uppercase (case-insensitive; forces all letters to uppercase).
If complying with ISO Entry SQL-92 standards, the system administrator should set delimited identifiers to mixed case.