Howto edit BLOB field in PHPMYADMIN

PHP Scripting Language Question

Hello All,

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.

Swiftguy

Default Text
 

Verified Answer?

The member who asked this question verified this comment provided the solution that solved their problem.

by:Posted on 2006-01-31 at 07:06:37ID: 15834053

This content is available to Experts Exchange members

See the answer now
with your Free 30 Day Trial

Get unlimited access to solutions & experts

  • 4,169,477 solved questions
  • 3,805 articles & videos
  • 15,413 tech experts

Get Access Now

Trusted by Thousands of Top Companies

  • CVS
  • IBM
  • Boeing
  • US Army
  • Kaiser
  • RalphLauren
  • Xerox
  • Cox
  • BlueCross
  • Accenture
  • Sony
  • Toyota
  • Allstate
  • Att
  • TomTom
  • BBC
  • Raytheon
  • Wells Fargo
  • US Navy
  • Direct TV
  • FootLocker
  • Nikon
  • BritishCouncil
  • TS Army
201501-LO-Qu-029

Related Questions We have nearly 4 million solutions here.

See More PHP Scripting Language Solutions

Experts Exchange powers the growth and success
of technology professionals worldwide.

  • Solve

    Experts Exchange is the tech professional’s trusted, on-demand resource for solving difficult problems, making informed decisions, and delivering excellent solutions.

  • Learn

    With unparalleled access to technical experts, verified real-world solutions, and diverse educational content, Experts Exchange enables personalized development of technology skills.

  • Network

    Experts Exchange gives you the professional exposure and valued relationships key to building the career you want.

Join the Network Today

See Plans and Pricing