[Phpmyadmin-devel] phpmyadmin destroy charcode 128-160

Steve Alberty alberty at neptunlabs.de
Thu Aug 9 11:17:35 CEST 2001


Hi,

this morning, i have detect a bug with
my binary tables.
phpMyAdmin convert (destroy) all data
from charcode 128 to 160 if you edit and
save a row within.

for example the charcode for the euro-symbol
chr(128) is converted to html entity €

---<MYSQL TABLE>---
CREATE TABLE Binary_Table (
  ID mediumint(8) unsigned NOT NULL auto_increment,
  MyData blob NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;
---</MYSQL>---
---<PHPCODE TO INSERT BINARY DATA>----
<?php
//for ($i=0,$binary="";$i<255;$i++,$binary.=chr($i)){}
for ($i=128,$binary="";$i<160;$i++,$binary.=chr($i)){}
$query="insert into Binary_Table (MyData) values
('".mysql_escape_string($binary)."')";
mysql_query($query);
?>
---</PHP>---

I think it is a major bug, because RC3 haven't this problem.

Regards,

--
Steve





More information about the Developers mailing list