16.20 - Hexadecimal Constants - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

Teradata Database converts hexadecimal constants as follows.

IF a UDF is passed a constant value that uses this hexadecimal notation … THEN Teradata uses this data type to determine the precedence order …
'hexadecimal_digits'XC

'hexadecimal_digits'XCV

VARCHAR
'hexadecimal_digits'XCF CHAR
'hexadecimal_digits'XBV VARBYTE
'hexadecimal_digits'XB

'hexadecimal_digits'XBF

BYTE
'hexadecimal_digits'X

'hexadecimal_digits'XI

'hexadecimal_digits'XI4

INTEGER
'hexadecimal_digits'XI8 BIGINT
'hexadecimal_digits'XI2 SMALLINT
'hexadecimal_digits'XI1 BYTEINT