UNHEX Function not Working in 9.5

4 posts
[expired user #8903]'s profile image [expired user #8903] posted 6 years ago in Running SQL scripts Permalink

I have using HeidiSQL ver 9.50.5196 and 9.4 on 9.5 version UNHEX() Function is not working. It does not shows proper output. But on 9.4 It Shows correctly. eg. SELECT HEX('A'), UNHEX('41') UNHEX('41') Should return 'A' but it Shows 0x41;

please do the needful.

1 attachment(s):
  • ERROR
10361 posts
ansgar's profile image ansgar posted 6 years ago Permalink

UNHEX returns values along with a binary collation, which HeidiSQL by default displays in hexadecimal format. You can activate "Show binary data as text" button to prevent that.

4 posts
[expired user #8903]'s profile image [expired user #8903] posted 6 years ago Permalink

Thank You for your response

Work Done

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