Found a bug about base64 decryption

sniper2's profile image sniper2 posted 7 years ago in HeidiSQL portable Permalink

Author! In a recent update to the new version, in the base64 decryption, there are the following questions, please check what is the problem.

1 attachment(s):
  • 2016-11-01_225438
ansgar's profile image ansgar posted 7 years ago Permalink

in the base64 decryption, there are the following questions

I can't see a question in your post.

kalvaro's profile image kalvaro posted 7 years ago Permalink

As it happens with every other SQL function, the implementation is provided by the DBMS. In this case, I presume it's MySQL:

MySQL reference

This is true even for portable editions of HeidiSQL. Remember: MySQL is a client-side program and HeidiSQL is only the client.

sniper2's profile image sniper2 posted 7 years ago Permalink

But there is no such problem in the low version, for example, 9.4.0.5126

sniper2's profile image sniper2 posted 7 years ago Permalink

execute select to_base64('123'),from_base64('MTIz')

ansgar's profile image ansgar posted 7 years ago Permalink

Looks good here, on HeidiSQL 9.4.0.5125.

1 attachment(s):
  • base64-results
sniper2's profile image sniper2 posted 7 years ago Permalink

But it's not in the latest version.

ansgar's profile image ansgar posted 7 years ago Permalink

You have probably the button "View binary data as text (instead of Hex)" not pressed. Find that in the context menu of the grid, then "Grid view options", then in the submenu.

sniper2's profile image sniper2 posted 7 years ago Permalink

OK,thanks!!!

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