I'm working with a database that uses BINARY(8) columns as primary keys for almost everything. (The database is provided by a third-party; I have absolutely no control over its structure.)
One of the things I often do is copy one of those keys from the result of a query into the SQL editor to create another query. However, two spaces are added between every byte. I have to remove those spaces and add "0x" to the beginning each time I copy a key.
Would it be possible for those spaces to be removed? I would really appreciate that. A "format BINARY strings as Java hexadecimal constants" option as a preference would be awesome, and another possibility. In that case, it would be reasonable to add a "0x" prefix and remove the spaces.
Notice: Clearwater Analytics will only send you information we think is relevant for your particular business. If you do not wish to receive these emails in the future, please respond with the word "Unsubscribe" in the Subject Line of the email. This e-mail message, together with any attachments, contains information of Clearwater Analytics and/or its affiliates that may be confidential, proprietary copyrighted and/or legally privileged, and is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please immediately delete it. The information we provide is from sources Clearwater Analytics considers reliable, but Clearwater Analytics provides no warranties regarding the accuracy of the information. Further, nothing in the email should be construed as legal, financial, or tax advice, and any questions regarding the intended recipient's individual circumstances should be addressed to that recipient's lawyer and/or accountant.