Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

TEXT


We will now explore how to use the TEXT field type and the relevant configuration values to adjust for the best possible phpMyAdmin behavior.

First we add to the book table a TEXT field called description:

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.

Note

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...