Now i want to convert hash column<byte(32)> to base16, just like from_bytes(hash_column,'base16'). but some results are different from that our user coverted using other tool.
take one record an example:
but I aslo convert above result from base16 to base, the result is the same.
My result: select from_bytes('20CD8BFE2E276DE235DD355F29F55D58B1897
User result: select from_bytes('DF327401D1D8921DCA22CAA0D60AA2A74E768E
From the result, the base12 result is the same, for my result, just the '-' is not coverted to base16.
Can anyone tell me how to handle the '-' in case my result mathch with user's result?
To avoid being treated as negative, just add leading zero byte: