Databases Reference
In-Depth Information
For a speciic column, it's possible to indicate only one type of transformation.
Here, the column is a
BLOB
. Hence, it can hold any kind of data. In order 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 ile format.
We will irst learn the purpose of these attributes and then try some possibilities in
the
Examples of transformation
section, later in this chapter.
Selecting the MIME type
The MIME speciication (
http://en.wikipedia.org/wiki/MIME
) has been
chosen as a metadata attribute to categorize the kind of data that a column holds.
Multipurpose Internet Mail Extensions
(
MIME
), originally designed to extend mail,
are now used to describe content types for other protocols as well. In the context of
phpMyAdmin, the current possible values are:
•
image/jpeg
•
image/png
•
text/plain
•
application/octetstream
The
text/plain
type can be chosen for a column containing any kind of text (for
example, XHTML or XML text). In the
Examples of transformations
section, you will
see which MIME type you are required to choose to achieve a speciic effect.
Browser transformations
This is where we set the exact transformation to be done. More than one
transformation may be supported per MIME type. For example, for the
image/
jpeg
MIME type, we have two transformations available:
image/jpeg: inline
for a
clickable thumbnail of the image, and
image/jpeg: link
to display just a link.
Search WWH ::
Custom Search