RFE: Add Decode (selected string) from Base64, Base 32, Hex to String using selected Charset

[t603]

Hello,

may I ask You to consider following RFE? RFE: Add Decode (selected string) from Base64, Base 32, Hex to String using selected Charset

The reason is for this RFE is to have a possibility to fast and inside SQuirreL SQL decode selected string (part of one ResultSet cell) from Base 64 or Base32 or Hex representation of string. Decoding has to support Charset encoding (like UTF8, windows-1250...), which is supported by Java API. Only user selected part of ResultSet cell would be decoded. See attached screenshot with suggested functionality. Decoded string would be printed into message window, where SQuirreL SQL already prints different messages, not to replace encoded string inside ResultSet cell window.

Regarding selecting charset encoding, I would suggest to add of all encodings by Java API into prefs.xml and XML skilled user will be responsible for removing unnecessary encodings and sorting the rest of them, so most frequently used encodings would be listed on top (so SQuirreL SQL will list encodings according to the sorting encodings inside prefs.xml). No GUI for editing in prefs.xml is necessary from my point of view. Selecting of Charset encoding will appear in SelectBox, because there will be hundreds of Charset encodings.

So, the user will select text by mouse, right mouse click, select Decode... from context menu, then select one of Base64 or Base 32 or Hex, then select Charset encoding from SelectBox to be used when converting the string, then Decode. Decoded string will be printed into message window.

Thank You in advance, Stepan

Test Case:

select 'Source string: Hello, how are You?
Source string Base64 encoded as UTF-8: SGVsbG8sIGhvdyBhcmUgWW91Pw==
Source string Base32 encoded as UTF-8: JBSWY3DPFQQGQ33XEBQXEZJALFXXKPY=
Source string Hex encoded as UTF-8: 48656c6c6f2c20686f772061726520596f753f' as "COLUMN_A"

[gerdwagner]

The following was implemented and will be available in future snapshots and versions:

Excerpt from change log:

#76
Cell data popup and cell detail display now offer right mouse menus to
Base64/Base32/Hex-decode selected text. The decoded text is written to the message panel.

[t603]

Hello, Gerd,

I tested it and it works almost OK. The only one thing is, what will happen, if encoded text is not encoded in UTF-8 Charset? I think, that each Decode functionality has to have selection of Charset. Java method has a parameter of Charset used for encoding and decoding. Am I right or not?

For example oXygen editor has two step decoding. The first step is choosing from Base64 or Base32 or Hex method and the second step is choosing from Charset. See the screenshot below.

I owe you a better explanation of this RFE: We have database with logs and there are some XML elements or JSON fields or partial varchars, where are strings encoded as Base64, Base32 Hex, which are encoded XML, JSON... etc.

Regards, Stepan

See example below from SQuirreL SQL 20251201_2126 when the string is encoded with Charset "windows-1250":

select 'Source string: příliš žluťoučký kůň úpěl ďábelské ódy
Source string Base64 encoded as windows-1250: cPjtbGmaIJ5sdZ1vdehr/SBr+fIg+nDsbCDv4WJlbHNr6SDzZHk=
Source string Base32 encoded as windows-1250: OD4O23DJTIQJ43DVTVXXL2DL7UQGX6PSED5HB3DMEDX6CYTFNRZWX2JA6NSHS===
Source string Hex encoded as windows-1250: 70f8ed6c699a209e6c759d6f75e86bfd206bf9f220fa70ec6c20efe162656c736be920f36479' as "COLUMN_A"

And decoding of each of above results using Charset UTF-8 results in:

p��li� �lu�ou�k� k�� �p�l ��belsk� �dy