Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

The MIME Column's Settings


If we go to the Table view of the Structure page for the book table and click the Change link for the cover_photo, we see three additional attributes for the fields:

  • MIME type

  • Browser transformation

  • Transformation options

For a specific field, it is possible to indicate only one type of transformation. Here, the field is a BLOB field, so it can hold any kind of data, but for phpMyAdmin to interpret and act correctly on the data, the transformation system must be informed of the data format and the intended results. Accordingly, we have to ensure that we upload data that always follows the same file format.

We will first learn the purpose of those attributes, and then try some possibilities in the Examples of Transformation section.

MIME Types

The MIME specification has been chosen as a metadata attribute to categorize the kind of data a column holds. The current possible values are:

  • image/jpeg

  • image/png

  • text/plain

  • application/octetstream

The auto-detect option...