2. Fundamentals of Using Querying and Reporting Tools : Naming and Name Use Conventions : Delimited Identifiers : Case Sensitivity in Delimited Identifiers
 
Share this page                  
Case Sensitivity in Delimited Identifiers
When specifying delimited identifiers, follow the rules for case as defined for your database. In standard Ingres databases, delimited identifiers can be either case sensitive or case insensitive, as determined by the DBA when creating the database. By default, standard Ingres databases are case insensitive.
In databases compliant with ANSI/ISO Entry SQL‑92 standards, delimited identifiers are case sensitive. The following is an example of a case‑sensitive delimited identifier:
"Sales for March"
For more information on setting case for identifiers in Ingres databases, see the Database Administrator Guide.