4. Maintaining a Distributed Database : Naming Conventions : Case
Share this page                  
Names that identify database objects can be uppercase, lowercase, or mixed case. In an Ingres Star database, the case of the object’s name as stored in the Ingres Star catalogs depends on:
The case‑translation semantics established when the database was created
How the user specifies the name of the object when it is created
Whether or not the user delimits the name of the object
Mixed-case names are allowed if the distributed database has been created specifying mixed-case delimited identifiers. For examples, see Naming Registration Examples. In addition, an object name must be delimited to preserve case.
Mixed-case names are not allowed if delimited identifiers are not used when registering an object. The case of the name will be uppercase or lowercase, depending on the case of regular identifiers specified at installation time.
In general, Ingres Star performs case translation in order to map the name of a registered object into the name of a local object. However, there are some restrictions on incorporating objects from mixed-case local databases or Enterprise Access products into a Ingres Star database that has been created without mixed-case delimited identifiers. For more information on delimited identifiers and Ingres Star, see Installation Options.