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
??? ??? ??? ??? ???
Chapter 16
[ 241 ]
text/plain
application/octetstream
The auto-detect option in the menu is yet to be implemented, so we do not use it.
The text/plain type can be chosen for a column containing any kind of text (for
example, XHTML or XML text).
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.
As we can see in the following image, moving the mouse over each choice in the
drop-down menu gives a short explanation of the corresponding transformation.
Pages:
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222