BINARY / VARBINARY Display

[sensph]

Hi,

I have just started to use dbForge. We use a lot of BINARY and VARBINARY fields for GSM data in our DB. When we use Heidi SQL to look at these fields for an MSISDN ( telephone number) we see the fields as ( for example) 0x447923123456. Which makes sense to us as a mobile phone number. In Heidi SQL we must unset "view BInary binary data as text", in order that Heidi display the binary data as HEX().

When we use dbForge to view the column we see(for example) 4��&. We have looked at the data Viewer and editor and for some fields ( if viewed as HEX) the value looks like we would expect.

However, for some longer VARBINARY(20) fields the HEX values displayed do not seem to be correct.

We are using MariaDB 10

Is there any way to trigger the viewing of columns, in the grid view, so we can see the value represented as we do in Heidi SQL?

i.e. something like 0x447923123456 (for MSISDN) or 0x0234301234567890 (for an IMSI)

Many Thanks.

Simon

[alexa]

Please try selecting 'utf8 -> Unicode (UTF-8)' on the 'Advanced' tab of the 'Database Connection Properties' dialog box that can be opened by right-clicking the connection in Database Explorer and selecting 'Modify Connection' from the popup menu.

[sensph]

Hi,

Setting the character set of the connection to match the character set of the database does resolve the problem of incorrect HEX data showing in the Data viewer. Thank you.

However is there any way to set the grid view for the column to display as hex, and not text which gives the odd characters 4��& ?

Essentially in grid view our table looks like this;

4��& | 28/11/2014 02:20:08 | 4��& etc...

and we need it to look like this;

0x12345678901234567 | 28/11/2014 02:20:08 | 0x4479230123456 etc.

Can how individual column are displayed be set? If so where?

Many Thanks,


Simon

[alexa]

Unfortunately, there is no such a possibility. However, you can vote for the following suggestion on our UserVoice forum http://devart.uservoice.com/forums/7729 ... ata-viewer

We collect and analyze the information from this forum in order to make a proper roadmap for future product releases.