Administration Guide > TDV Configuration Options > Configuring Case Sensitivity and Trailing Spaces Settings > Mismatch Effects on String Comparisons
 
Mismatch Effects on String Comparisons
The case-sensitive and trailing-spaces policies affect string comparison. The policies do not affect the actual value of strings. Affected functions and operators include the following.
Case Mismatch
Trailing Spaces
Comparison operators in WHERE and JOIN ON: =, <, <=, >=, >, and <>
Comparison operators in WHERE and JOIN ON: =, <, <=, >=, >, and <>
REPLACE (src,pattern,escape)
The pattern is matched according to the policy.
LENGTH (column)
The string length returned does not include trailing spaces.
MIN (column)
The strings ‘ABC’ and ‘abc’ are considered the same, so either can be chosen by this function.
MIN (column)
The strings ‘abc   ’ and ‘abc’ are considered the same, so either can be chosen by this function.
MAX (column)
The strings ‘ABC’ and ‘abc’ are considered the same, so either can be chosen by this function.
MAX (column)
The strings ‘abc  ’ and ‘abc’ are considered the same, so either can be chosen by this function.
GROUP BY
The strings ‘ABC’ and ‘abc’ are considered the same, so the group include sboth sets of values.
GROUP BY
The strings ‘abc   ’ and ‘abc’ are considered the same, so the group includes both sets of values.
ORDER BY
The strings ‘ABC’ and ‘abc’ are considered the same, so they sort together and can be intermixed.
ORDER BY
The strings ‘abc   ’ and ‘abc’ are considered the same, so they sort together and can be intermixed.