Result Type - Analytics Database - Teradata Vantage

If the data type of string1 is CHAR or VARCHAR, the result data type is INTEGER.

If the data type of string1 is CLOB, the result data type is BIGINT.