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
Plz help me out.
Thx in advance.
Experts Exchange members save,
on average, 2.5 hours per week.
Darth Mod has answered 10,420 questions on Experts Exchange and is an expert in Wireless Hardware, Citrix and Windows XP.