SQL Reference Guide > SQL Reference Guide > H. Settings for Strict ANSI Compliance > ISO_ENTRY_SQL-92 Parameter > Case Sensitivity for Identifiers
Was this helpful?
Case Sensitivity for Identifiers
The ANSI Entry SQL-92 standard specifies how case is handled for identifiers (names of tables, for example). Identifiers can be quoted or unquoted (regular or delimited (see Regular and Delimited Identifiers)).
Regular Identifiers
ANSI/ISO Entry SQL-92
Regular identifiers are treated as upper case:
dbmsinfo('db_name_case') returns UPPER.
Ingres Default
Regular identifiers are treated as lower case:
dbmsinfo('db_name_case') returns LOWER.
Delimited Identifiers
ANSI/ISO Entry SQL-92
Delimited identifiers are case-sensitive:
dbmsinfo('db_delimited_case') returns MIXED.
Ingres Default
Delimited identifiers are not case-sensitive:
dbmsinfo('db_delimited_case') returns LOWER.
User Names
ANSI/ISO Entry SQL-92
User names are treated as upper case:
dbmsinfo('db_real_user_case') returns UPPER.
Ingres Default
User names are treated as lower case:
dbmsinfo('db_real_user_case') returns LOWER.
Last modified date: 08/29/2024