Attribute

UppercaseIdentifiers

Purpose

Specifies whether the driver maps all identifier names to uppercase.

Valid Values

true | false

The value for this option is specified as a key=value pair in the Config Options field. See "Config options" for details.

Behavior

If set to true, the driver maps identifiers to uppercase.

If set to false , the driver maps identifiers to the mixed case name of the object being mapped. If mixed case identifiers are used, SQL statements must enclose those identifiers in double quotes and the case of the identifier must exactly match the case of the identifier name.

Example

For example, if UppercaseIdentifiers=false, to query the Account table you specify:

SELECT "id", "name" FROM "Account"

Notes

  • Do not change the value of UppercaseIdentifiers unless the data source you are connecting to has objects with names that differ only by case.

Default

true

GUI Tab

For Windows:

The value for config options are specified in the Config Options field on the Advanced tab.

For UNIX/Linux:

The value for config options are specified in the Config Options field on the Schema Tool. For details, see "Starting the Schema Tool on UNIX/Linux."

See also