Purpose

Determines how the driver handles the mapping of native identifiers containing characters that would require them to be quoted in SQL statements.

Valid Values

Strip | Include | Replace

Behavior

If set to Strip, the driver removes any characters that are not part of a legal, unquoted SQL identifier. In practice, this removes any characters that are not letters, digits, or underscores. For example, if the native name were Cost of Customer Acquisition, the mapped name would be CostofCustomerAcquisition.

If set to Replace, the driver replaces any characters that would cause the identifier to be quoted with underscores. For example, if the native name was Yearly Cost Percentage, the mapped name would be Yearly_Cost_Percentage.

If set to Include, the driver does not modify native identifiers; therefore, identifiers containing characters that are not letters, digits, or underscores would need to be quoted. For example:

SELECT "Long & (Very) Unusual Field/Name" FROM "Oddly-Named+Table"

Data Source Methods

public String getSpecialCharBehavior()

public void setSpecialCharBehavior(String)

Default Value

Include

Data Type

String