============================================== Hexadecimal Numeric and Binary String Literals ============================================== Support for hexadecimal numeric and binary string literals. Authors: Bill Oliver Adriano dos Santos Fernandes Syntax: ::= { 0x | 0X } [ ... ] ::= { x | X } [ { }... ] ::= 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 ::= | A | B | C | D | E | F | a | b | c | d | e | f Notes (numeric hex literal): - The max number of should be 16. - If the number of is greater than 8, the constant data type is a signed BIGINT. If it's less or equal than 8, the data type is a signed INTEGER. That means 0xF0000000 is -268435456 and 0x0F0000000 is 4026531840. Notes (binary string literal): - The resulting string is defined as a CHAR(N / 2) CHARACTER SET OCTETS, where N is the number of . Example: select 0x10, cast('0x0F0000000' as bigint) from rdb$database; select x'deadbeef' from rdb$database;