I'm trying to investigate an issue with a query I'm currently debugging.
The error I get from my client code is the following:
Duplicate entry '\x9F\x98\x9Ern\x06\x8BN\x97\x8D\xB5A\xB5e\x12\xC9-\x9C\xE1\x1Ai\' for key 'PRIMARY'.
How do I convert this binary string value to its original value so I can find out which part of my SQL query it belongs to? My goal would be to take this string and be able to convert it back to its binary(16) equivalent.
I found this MySQL documentation that explains briefly how the conversion works, but I'm not sure how to proceed in SQL.