show blob data as ascii

[michabbb]

dear support,

the client is able to display blob data as image, if it is one.
why is there no option to display the binary data as ascii ?
in my case, i have a system which stores key-value-data into a blob field.
i am not able to read this, or i didn´t find the option to see the ascii translation of it.

thank you for any help.
micha

[alexa]

We would recommend you to try adjusting the connection to this text. Right-click the connection in Database Explorer, select 'Modify Connection' in the popup menu, switch to the 'Advanced' tab in the Database Connection Properties dialog box, and select, for example, UTF8 in the 'Encoding' dropdown menu.

[michabbb]

thank you, but the connection is already setup as utf8... the data i see looks like this:



tools like phpmyadmin (as it was told to me) convert the value automatically to ascii, that´s in fact the option i am searching for in dbforge...

[alexa]

The connection encoding should match the encoding in the blob.

tools like phpmyadmin (as it was told to me) convert the value automatically to ascii, that´s in fact the option i am searching for in dbforge...

It means that the connection encoding in phpmyadmin deffers from UTF8

[michabbb]

okay, but that does not help me here, is there any way to see this data as ascii by clicking on a magic icon somewhere ?

[alexa]

There may be the situation when different cells may contain text with different encodings, so the connection encoding needs to be always changed in order to satisfy different cells.

[michabbb]

thank you for your feedback. something i didn´t know or got the info too late: the data in my case here is DECODED, so of course i see strange characters ;-(( sorry