Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

UNHEX Function not Working in 9.5

yogeshmkumbhar's profile image yogeshmkumbhar posted 9 months 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's profile image ansgar posted 9 months 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's profile image yogeshmkumbhar posted 9 months ago

Thank You for your response

Work Done

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