Oracle RAW(16) datatype shows wrong

[DriesSch]

Hello guys

I recently started using DBeaver, I must say it's an enormous advantage compared to Oracle SQL Developer.
There is an issue though, we use the datatypeRAW(16) with a default of sys_guid() for primary keys. When doing a select in OSD it shows a normal GUID, in DBeaver it shows some weird symbols. What could be wrong?

[serge-rider]

Could you post sample DDL/insert?

[DriesSch]

Thanks for the quick reply!

Table is created like this:
CREATE TABLE MCVSSETDEF(
PKMCVSSETDEF RAW(16) DEFAULT sys_guid(),
GROEP CHAR(4) NOT NULL,
NAAM VARCHAR2(35) NOT NULL,
TIJDUPDATE DATE DEFAULT SYSDATE,
GEBRUIKER VARCHAR2(8) DEFAULT USER,
CONSTRAINT MCVSSETDEF_PK PRIMARY KEY (PKMCVSSETDEF)
);

After I did this insert: INSERT INTO MCVSSETDEF (groep, naam) values('2238','TestSet');
I do this select: SELECT * FROM MCVSSETDEF;

I get this result:

In Oracle SQL Developer I get this result:

Is that the info you need?

[serge-rider]

Yes, thanks.
You can change binary presentation in preferences:

So results will look just like in SQL Developer:

[DriesSch]

Wonderful, thanks for the quick replies and the solution!

[srinivas-os]

Note: For anyone like me using 4.3.5, this option is under Preferences -> Result Sets -> Editors now.

[SeabiscuitCZX]

I'm using 5.0.4, the option same as your

[SeabiscuitCZX]

I'm facing another issue. after changed this option, the display is fine.
but i did select like SELECT * FROM DEVICE_REGISTRATION d WHERE d.REGISTRATION_ID = 'B69A7BC09C4D428B84EE059EED78348B'; the REGISTRATION_ID type is RAW(16). nothing selected.

[serge-rider]

This should work.
I've also fixed native Oracle hex formatter (so you can use result "Filter by" menu).

[SeabiscuitCZX]

SELECT * FROM table t WHERE t.ID = HEXTORAW('E6B92841FC9E4CBF97607D87389439C3'); i'v tried this way. it worked.

[yannickvidal]

In DBeaver v6.0.1, the option is now under Window > Preferences > Editors > Data Editor > LOB Editors

[ovidiugabriel]

This answer is obsolete. The option is now under Window > Preferences > Editors > Data Editor > LOB Editors.

Yes, thanks.
You can change binary presentation in preferences:

So results will look just like in SQL Developer:

[ovidiugabriel]

This changed once again on 7.3 it is in Editors > Data Editor > Binary Editors