Bug #62213 Add option to format numbers in hex
Submitted: 19 Aug 2011 14:25 Modified: 20 Aug 2011 6:58
Reporter: James Ots Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[19 Aug 2011 14:25] James Ots
In the software I am working on, our ids are called fingerprints, and are always referred to in hex. It would be really nice if, when I open a table in the workbench to browse and change data, it could default to displaying the values in hex instead of decimal, without me having to specifically write a query using the HEX() function every time.

In my case in particular, I would want any numeric fields named 'fingerprint' or ending in '_fp' to be displayed in hex.

Initially I was thinking there might be a scripting hook where I could conditionally format the numbers like this, but since it isn't available it was suggested on IRC that I raise a feature request here.

Ideally, I would be able to get the system to automatically display certain fields using a custom format, based on some conditions. (I imagine in this case the column would probably be coloured differently to indicate that it is not exactly what came out of the query). But almost as useful would be the ability to right click on a number field's column header and choose 'Display as... Hex'.

How to repeat:
[20 Aug 2011 6:58] Valeriy Kravchuk
Thank you for the feature request.