Parameter | Description |
Case Sensitivity | Controls the default case sensitivity of queries. The default value of False ignores case in string comparisons. If this setting does not match the case-sensitivity setting of a data source, performance is degraded when querying that source. Changing this has no effect on currently running queries. |
Ignore Trailing Spaces | Controls whether to ignore trailing spaces during string comparisons in queries. The default value of True ignores trailing spaces during string comparisons. If this setting does not match the trailing spaces setting of a data source, performance is degraded when querying that source. Changing this has no effect on currently running queries. |
Parameter | Description |
Disable Case Sensitivity Correction | Determines whether the server uses UPPER functions to normalize the SQL when case sensitivity settings do not match. The default value is False. |
Disable Ignore Trailing Spaces Correction | Determines whether the server uses TRIM functions to normalize the SQL when “ignore trailing spaces” settings do not match. The default value is False. |
Character Functions Conform to Case Sensitivity Setting | Determines whether the server execution of character functions conforms to the case sensitivity setting of the query execution environment. If not, functions TRIM, BTRIM, LTRIM, RTRIM, INSTR, POSITION, STRPOS and TRANSLATE are case sensitive when executed within TDV. The default value is True. |
Push Even if Case Sensitivity Mismatch | Determines whether the server ignores case sensitivity setting differences between the server and the data source. The default value is False. |
Push Even if Trailing Spaces Mismatch | Determines whether the server ignores trailing space setting differences between the server and the data source. The default value is False. |