Case Sensitivity of Identifiers

2. Introducing SQL : SQL Naming and Statement Rules : Regular and Delimited Identifiers : Case Sensitivity of Identifiers

Share this page

Case sensitivity for regular and delimited identifiers is specified at the time a database is created. By default, delimited identifiers are not case sensitive. To comply with ANSI/ISO Entry SQL-92, however, delimited identifiers must be case sensitive.

The DBMS Server treats database, user, group, role, cursor, and location names without regard to case. Mixed-case database or location names cannot be created.

To determine the settings for the database to which a session is connected

Use the DBMSINFO function (see DBMSINFO Function--Return Information About the Current Session), as follows:

SELECT DBMSINFO('DB_NAME_CASE')

and

SELECT DBMSINFO('DB_DELIMITED_CASE')