Found a bug about base64 decryption

sniper2 posted 3 years ago in HeidiSQL portable

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 posted 3 years ago

in the base64 decryption, there are the following questions

I can't see a question in your post.

kalvaro posted 3 years ago

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 posted 3 years ago

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

sniper2 posted 3 years ago

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

ansgar posted 3 years ago

Looks good here, on HeidiSQL 9.4.0.5125.

1 attachment(s):
  • base64-results
sniper2 posted 3 years ago

But it's not in the latest version.

ansgar posted 3 years ago

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 posted 3 years ago

OK,thanks!!!

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