The StringSimilarity function calculates the similarity between two strings, using the specified comparison method. The similarity is a value in the range [0, 1].
- This function requires the UTF8 client character set for UNICODE data.
- This function does not support Pass Through Characters (PTCs).
For information about PTCs, see Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125.
- When comparing strings, the function assumes that they are in the same Unicode script in Normalization Form C (NFC).
- When used with this function, the ORDER BY clause supports only ASCII collation.