Database Reference
In-Depth Information
MIME-Based
Transformations
In this chapter, we will cover a powerful phpMyAdmin feature—its ability to
transform a column's contents during a table
Browse
, based on certain specific
rules called transformations. Normally, browsing a table shows only the original
data that resides in it. However, MIME-based transformations permit alteration of
the display format.
Display behavior in browse mode
Normally, the exact contents of each row are displayed, except that:
•
The
TEXT
and
CHARACTER
fields might be truncated, according to
$cfg['LimitChars']
, depending on whether we have chosen to see
Full
Texts
or not
BLOB
•
fields might be replaced by a message such as
[BLOB - 1.5 KB]
We will use the term
cell
to indicate a specific column of a specific row. The cell
containing the cover photograph for the "Future souvenirs" book (a
BLOB
column)
is currently displayed as cryptic data such as
‰PNG\r\n\Z\n\0\0\0\rIHDR\0
or
as a message stating the
BLOB
field's size. It would be interesting to see a thumbnail
(shown in the second screenshot under the
Clickable thumbnail
section) of the picture
directly in phpMyAdmin and possibly the full-size picture itself. This will be made
possible with proper transformation.
Search WWH ::
Custom Search