Hexadecimal Constants | SQL External Routine Programming | Teradata Vantage - 17.10 - Hexadecimal Constants - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

Teradata 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