Databases Reference
In-Depth Information
There are three parameters that control the layout of the text area that will be
displayed in Insert or Edit mode for the
TEXT
fields. First, the number of columns
and rows for each field is defined by:
$cfg['TextareaCols'] = 40;
$cfg['TextareaRows'] = 7;
This gives (by default) the following space to work on a
TEXT
field:
The settings impose only a visual limit on the text area, and a vertical scroll bar is
created by the browser if necessary.
Although
MEDIUMTEXT
,
TEXT
, and
LONGTEXT
columns can accommodate more than 32K of data, some
browsers cannot always edit them with the mechanism
offered by HTML: a text area. In fact, experimentation has
convinced the phpMyAdmin development team to have
the product display a warning message, if the contents are
larger than 32K, telling users that it might not be editable.
The last parameter has an impact for
LONGTEXT
fields. Setting
$cfg['LongtextDo
ubleTextarea']
to
TRUE
doubles the available editing space.
BLOB (Binary Large Object) Fields
BLOB
fields are usually used to hold binary data (such as images and sounds), even
though the MySQL documentation implies that
TEXT
fields could be used for this
purpose. The MySQL 5.1 manual says "In some cases, it may be desirable to store
binary data such as media files in
BLOB
or
TEXT
columns" but another phrase,
"
BLOB
columns are treated as binary strings (byte strings)" seems to indicate that
binary data should really be stored in
BLOB
fields. Thus, phpMyAdmin's intention
is to work with
BLOB
fields to hold all binary data.
Search WWH ::
Custom Search