In the editing interface, certain special characters that are already stored in the database are not displayed. For example, the string “ABC” 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:
We have a transformation that permits to display in hex.
Hi,
I can see the special characters in editing interface just as in terminal.
see the attached screenshot or did i get it wrong?
The editing interface is the panel that appears after you click on Edit for a row.
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
But in browse interface the special character is hidden.
The column value which is showing as "nnnn" is actually nn<special char="">nn.
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.