Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

password query display hex code

orean's profile image orean posted 4 years ago in Running SQL scripts Permalink

When I excute "select password('test')"

This is returned hex string

"0x2A39344244434542453139303833434532413146393539464430324639363443374146344346433239"

heidisql version is 9.5

How Can I fix this error?

kalvaro's profile image kalvaro posted 4 years ago Permalink

This happens because your server incorrectly reports the columns as binary. If I'm not wrong this was fixed several some years ago so upgrading MySQL Server to a recent version should fix the issue (unless it's a recurring bug that comes and go, I can't tell for sure). Alternatively, you can click the "View binary data as text (instead of HEX)" button in HeidiSQL.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.