Display integers as hexadecimal

matsg's profile image matsg posted 8 years ago in Feature discussion Permalink

Hi,

I wonder if it might be possible to display integers returned in a result set as hexadecimal instead? We're working with 64-bit ID's that are bit-coded a certain way, and it's much easier to work with 0x0000,00A5,0000,299F instead of 708,669,614,495.

I know MySQL has functions to convert between integer and hexadecimal, but I'm not interested in that - I just thought it would be much nicer to see the hexadecimal representation in the query result set. It's all just numbers anyway... :)

Matt

Please login to leave a reply, or register at first.