UNHEX Function not Working in 9.5

yogeshmkumbhar posted 2 weeks ago in Running SQL scripts

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
ansgar posted 2 weeks ago

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.

yogeshmkumbhar posted 2 weeks ago

Thank You for your response

Work Done

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