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.