Binary literals use hexadecimal bytes to represent the binary data.
Binary literals must be prefixed by a capital or lower case X followed by a single quote character, and suffixed by a single quote character.
If the "Use Quoted Delimiters" option is not selected in the data dictionary, then character literals can also be prefixed and suffixed by a single double quote character.
The precision of the literal will be the count of all characters inside the quotes divided by two.
Examples of Binary Literals:
Literal |
Data Type |
x'AF034879F0CC' |
binary(6) |
x'' (empty quotes) |
binary(0) |