Teradata converts string constant values passed to UDFs as follows:
| String Constant Value | Data Type That Determines Precedence Order |
|---|---|
| String in apostrophes | VARCHAR |
| Graphic string in apostrophes | VARCHAR CHARACTER SET GRAPHIC |
Teradata does not implicitly convert character string constants that represent numeric values to numeric types unless the constants are part of an expression. For example, the string constant '1024' remains a character string. However, in an expression such as '1024' - 1, Teradata does convert the character string to a REAL, according to Teradata implicit conversion rules.
See Teradata Vantage™ - Data Types and Literals, B035-1143.