16.20 - StringSimilarity - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engine Analytic Functions

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
July 2019
Content Type
Programming Reference
Publication ID
B035-1206-162K
Language
English (United States)

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.
  • This function does not support Pass Through Characters (PTCs).

    For information about PTCs, see Teradata Vantage™ NewSQL 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.