What is binary data character?

[expired user #7211]'s profile image [expired user #7211] posted 11 years ago in General Permalink
I select binary column.
HeidiSQL display binary with HEX.

What is character set with HEX?

I use HeidiSQL Portable 8.0.0.4396 in Windows Vista.
ansgar's profile image ansgar posted 11 years ago Permalink
You can activate the "View binary data as text" button on the top tool bar (the fourth button from the right).
[expired user #7211]'s profile image [expired user #7211] posted 11 years ago Permalink
Thanks for your reply.

I am already using that button.

I want to know character set of text. For example, it is ASCII, UTF-8, UTF-16.
ansgar's profile image ansgar posted 11 years ago Permalink
Look into the table definition?
kalvaro's profile image kalvaro posted 11 years ago Permalink
The concept of character encoding makes sense when you have text columns, not binary ones. Binary means that it isn't text.
[expired user #7211]'s profile image [expired user #7211] posted 11 years ago Permalink
I use "View binary data as text" Button.

table definition is below:
character_set_server = utf8mb4
character_set_database = utf8mb4
jfalch's profile image jfalch posted 11 years ago Permalink
show the table definition (CREATE TABLE statement).
jfalch's profile image jfalch posted 11 years ago Permalink
(the one from heidisql´s Create code tab.)

Please login to leave a reply, or register at first.