editbreaksblobfields,changedfromNULLto''

Forwarded from
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=354919

Package: phpmyadmin
Version: 4:2.7.0-pl2-1
Severity: important

Hi,

Use this database:

CREATE TABLE

(

blob,

text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO

VALUES (NULL, 'DUMMY');

Now edit this value using the phpmyadmin-interface
the following code is
generated even if NO new value has been entered:

UPDATE

SET

= '' WHERE
CONVERT(

USING utf8 )
IS NULL AND CONVERT(

USING utf8 ) =
'DUMMY' LIMIT 1 ;

And the result is:

CREATE TABLE

(

blob,

text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO

VALUES ('', 'DUMMY');

The NULL in blobby has become a ''.

There is NO possibility (apart from running the
sqlcode by hand) to set the
field to his original-null-value.

This error happens if ProtectBinary is "FALSE",
"blob" and "all".

Greetings

Torsten

• Original URL: "https://sourceforge.net/p/phpmyadmin/bugs/2082/":https://sourceforge.net/p/phpmyadmin/bugs/2082/


• Original author: d3xter


• Found in version: 2.8.0.1

该提问来源于开源项目：phpmyadmin/phpmyadmin