In the Data Explorer, when I do
SELECT CAST( 123456 AS BINARY(4) );
I get an output of:
But, according to the docs the output is "usually":
I've been looking around, but couldn't find any explanation of the first-mentioned output.
Can someone explain the first-mentioned output and what caused it?
Bonus but slightly off topic:
How I would get the actual hex representation or convert the one to the other?
I originally asked this on StackOverflow, but I was led to believe that this is caused by some intermediate processing (not directly caused by the database) and should thus be here.