Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#2082 (ok 2.9.0) edit breaks blob-fields, changed from NULL to \'\'

2.8.0.1
fixed
Marc Delisle
1
2013-06-11
2006-03-16
Piotr Roszatycki
No

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 `demo` (
`blobby` blob,
`textty` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `demo` 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 `demo` SET `blobby` = '' WHERE
CONVERT( `blobby` USING utf8 )
IS NULL AND CONVERT( `textty` USING utf8 ) =
'DUMMY' LIMIT 1 ;

And the result is:

CREATE TABLE `demo` (
`blobby` blob,
`textty` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `demo` 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

Discussion

  • Marc Delisle
    Marc Delisle
    2006-03-16

    • assigned_to: nobody --> lem9
     
  • Marc Delisle
    Marc Delisle
    2006-03-17

    • assigned_to: lem9 --> nobody
     
  • Marc Delisle
    Marc Delisle
    2006-05-26

    • assigned_to: nobody --> lem9
     
  • Marc Delisle
    Marc Delisle
    2006-05-26

    • priority: 5 --> 1
    • summary: edit breakes blob-fields and changed it from NULL to '' --> (ok 2.9.0) edit breaks blob-fields, changed from NULL to ''
    • status: open --> open-fixed
     
  • Marc Delisle
    Marc Delisle
    2006-05-26

    Logged In: YES
    user_id=210714

    Fixed for 2.9.0

     
  • Marc Delisle
    Marc Delisle
    2006-09-20

    • summary: (ok 2.9.0) edit breaks blob-fields, changed from NULL to '' --> (ok 2.9.0) edit breaks blob-fields, changed from NULL to \'\'
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-fixed --> fixed