#4555 Special characters invisible in editor

[Ann + J.M.]

In the editing interface, certain special characters that are already stored in the database are not displayed. For example, the string “ABC” contains a special character 0x81 between “A” and “B”, which is hidden in phpMyAdmin, while the mysql command line tool displays it as “A?BC”.

Suggestions:

• Display an indicator of the hidden character so the user can see it.
• Show a warning message that the field contains hidden / special characters.
• Allow the user to view the field data as BLOB or rawurlencoded.

[Marc Delisle]

We have a transformation that permits to display in hex.

[Rakesh Kumar]

Hi,
I can see the special characters in editing interface just as in terminal.

see the attached screenshot or did i get it wrong?

[Marc Delisle]

The editing interface is the panel that appears after you click on Edit for a row.

[Rakesh Kumar]

The special character is also visible on the interface that appears after clicking edit. that time i was not able to attach more than one screenshot.

see the attached screenshot

[Rakesh Kumar]

But in browse interface the special character is hidden.

The column value which is showing as "nnnn" is actually nn<special char="">nn.

[Marc Delisle]

Rakesh,
you're right, I cannot reproduce this problem either, with version 4.3.3. I used
CREATE TABLE IF NOT EXISTS bug_4555 (
c0 int(11) NOT NULL,
c1 varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
insert into bug_4555(c0, c1) values(1, concat('A', 0x81, 'BC'));

and I tested with Firefox (Iceweasel 31.3).

Ann + J.M., please give more details to reproduce.