Databases Reference
In-Depth Information
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
column's size. It would be interesting to see a thumbnail
(shown in the following screenshot) of the picture directly in phpMyAdmin
and possibly the full-size picture itself. This will be made possible with proper
transformation.
Switching display options
In
Browse
mode, the
Options
link reveals a slider that contains, among other
choices, a
Hide Browser transformation
checkbox. We can use it whenever we want
to switch between viewing the real data of a cell and its transformed version.
Enabling transformations
We define
transformation
as a mechanism by which all the cells related to a column
are transformed at browse time, using the metadata defined for this column. Only
the cells visible on the current results page are transformed.
The use of this feature is controlled by the
$cfg['BrowseMIME']
directive in
config.inc.php
. The default value of this directive is
TRUE
, meaning that
transformations are enabled. However, the phpMyAdmin configuration storage
must be in place (refer to
Chapter 1
) as the metadata necessary for the transformation
is not available in the official MySQL table structure. It's an addition made especially
for phpMyAdmin.
Search WWH ::
Custom Search