Configuring Case Sensitivity and Trailing Spaces Settings
Case sensitivity and trailing space mismatches are common when working with different data sources. By default TDV is set to be case insensitive and to ignore trailing spaces. Changing the policy might change query results or performance. This section describes configuration tasks you can perform to control TDV behavior for case sensitivity and trailing spaces.
For example, the test (‘ABC’ = ‘abc’) returns False for a case-sensitive comparison and True for a non-case-sensitive comparison. The test (‘ABC ’ = ‘ABC’) returns False when trailing spaces are considered and True when trailing spaces are ignored.
With TDV, case sensitivity and trailing spaces mismatches occur only under the following conditions:
• A mismatch between TDV and the underlying data source’s case sensitivity or trailing spaces settings.
• A WHERE clause that contains a CHAR or VARCHAR.
The following topics are covered in this section: