MYSQL _binary format for UUID

35 Views Asked by At

Looking at the general_log table I see queries are being logged as binary uuid (which is fine) but I dont quite understand the format. I can't even find information around this binary representation.

For instance, this binary value 0x46f9c3b997d339ce3bdfecdf0e8d63dd appears in the log as _binary'F\xF9ù\x97\xD39\xCE;\xDF\xEC\xDF\x8Dc\xDD'. I'm failing to see how this is transformed and more important how to transform it back.

1

There are 1 best solutions below

0
danijepg On

Ah ok not that hard, following some comments the only thing that needs to be done is detect \x as hex (next 2 chars), convert rest to HEX similar to mysql HEX function, concat results.