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
-- System Information:
Debian Release: testing/unstable
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.13
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15)
Versions of packages phpmyadmin depends on:
ii apache2 2.0.55-4 next generation, scalable, extenda
ii apache2-mpm-prefork [httpd] 2.0.55-4 traditional model for Apache2
ii debconf [debconf-2.0] 1.4.70 Debian configuration management sy
ii php4 4:4.4.2-1 server-side, HTML-embedded scripti
ii php4-cgi 4:4.4.2-1 server-side, HTML-embedded scripti
ii php4-mysql 4:4.4.2-1 MySQL module for php4
ii php5-mysql 5.1.2-1 MySQL module for php5
ii ucf 2.005 Update Configuration File: preserv
Versions of packages phpmyadmin recommends:
pn php5-mcrypt | php4-mcrypt <none> (no description available)
-- debconf information:
* phpmyadmin/webserver: apache, apache2
* phpmyadmin/restart: true
* phpmyadmin/reconfigure-webserver: apache, apache-ssl, apache-perl, apache2
* phpmyadmin/restart-webserver: true
phpmyadmin/changed-extension:
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
