Administration Guide > TDV Configuration Options > Configuring Case Sensitivity and Trailing Spaces Settings > Setting Server-wide Case and Trailing Space Behavior Using Configuration Parameters
 
Setting Server-wide Case and Trailing Space Behavior Using Configuration Parameters
TDV uses the configuration parameter values for case sensitivity and trailing spaces that have been set in the Studio Configuration window. This is useful if the data sources have consistent case and trailing space behavior among themselves. However, if you change configuration parameter settings, TDV also needs to re-evaluate other query plans against the new settings.
Note: Configuration parameters settings are server-wide. They are overridden at the session level by client interface property settings. Parameter and property settings are in turn overridden by query options.
To configure case and trailing space behavior using configuration parameters
1. Log into Studio as the admin user.
2. From the Administration menu, choose Configuration.
3. In the tree pane, navigate to TDV Server > SQL Engine > SQL Language.
4. Determine the best settings for the following parameters.
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.
5. In the tree pane, navigate to TDV Server > SQL Engine > Overrides.
6. Determine the best settings for the following parameters.
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.
7. Click Apply.
8. Click OK.
9. Restart the TDV Server.