#1223 BINARY field display as [B@12345 in Database Manager

[Anonymous]

Other data types are represented in roughly the same syntax as their literals. The current display of Binary types is unusable.

INSERT INTO BINTEST (id) VALUES (X'012345')

SELECT id FROM BINTEST

ID
-------------------
[B@556860

This should be:

ID
-------------------
X'012345'

Or

ID
----------------------
012345

[Fred Toussi]

We may introduce a setting to allow the return of binary values as strings.

[Fred Toussi]

From version 2.5.2 binary values are displayed as strings in DatabaseManagerSwing.