The following query:
SELECT CAST (TO_BYTES ('5A', 'base16') as BYTE (16)); TO_BYTES('5A','base16')
returns '5A-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00 '
The following query:
SELECT CAST (TO_BYTES ('5A', 'base16') as BYTE (16)); TO_BYTES('5A','base16')
returns '5A-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00 '