Attribute

SpecialCharBehavior (scb)

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

0 | 1 | 2

Behavior

If set to 0 (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 2 (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 1 (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"

Default Value

0 (Strip)