Given a binary(16) column, how do I display its value as a hexadecimal number? I've been experimenting in the console a little below, and I'm not getting the results I expect. Could it be that I'm not converting numbers to binary properly?
I have the following sample query: select hex(cast(10 as binary)),
but the output is rather unexpected: 3130.
Basically, it appears to just take the decimal representation of the number, and insert a 3 digit before each digit, e.g. 2 -> 32, 22 -> 3232, 678 -> 363738, etc.
If I specify a length for the binary data type (e.g. binary(16)), I get the same behavior, except that it gets padded on the right with the required number of 0s.
Obviously, that's not what I'm looking for. What am I missing?
EDIT: just tried convert(678, binary) instead of cast, same behavior.
解决方案
Why make things complicated? I just use this to display the value of a BINARY(16) column:
SELECT HEX(colname);