Teradata converts string constants as follows.
| IF a UDF is passed this constant value … | THEN Teradata uses this data type to determine the 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 they 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.
For more information on implicit type conversion rules, see Teradata Vantage™ - Data Types and Literals, B035-1143.