Howto edit BLOB field in PHPMYADMIN
Posted on 2005-06-12
I have a table having Blob datatype having more than 1000 records. I use Phpmyadmin for mysql maintenance.
Phpmyadmin does not display or edit columns of Blob datatypes? Now i have to edit a blob field how do i do that in phpmyadmin?
i thought changing columns of 'blob' datatype to text or char would atleast help me in browsing/editing the data .....but was unable to change datatypes :(
following was the error when i tried to change blob datatype to char datatype
(mysql#) alter table electrical change address address text character set utf8;
ERROR 3 (HY000): Error writing file './property/#sql-b0d_5.frm' (Errcode: 28)
Plz help me out.
Thx in advance.