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. |