Teradata Database 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 Database 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.