Data Entry Panel Tuning for CHAR and
VARCHAR
By default, phpMyAdmin displays an input field on a single line for the field
types, CHAR and VARCHAR. This is controlled by setting $cfg['CharEditing'] to
'input'. Sometimes we may want to insert line breaks (new lines) within the field.
(This insertion might be done manually with the Enter key, or while copying and
pasting lines of text from another on-screen source.) This can be done by changing
$cfg['CharEditing'] to 'textarea'. This is a global setting and will apply to all
fields of all tables, for all users of this copy of phpMyAdmin.
Chapter 4
[ 75 ]
We can tune the number of columns and rows of this text area with:
$cfg['CharTextareaCols'] = 40;
$cfg['CharTextareaRows'] = 2;
Here, 2 for $cfg['CharTextareaRows'] means that we should be able to see
at least two lines before the browser starts to display a vertical scroll bar. These
settings apply to all CHAR and VARCHAR fields, and using them would generate a
different Insert screen as follows:
With this entry mode, the maximum length of each field no longer applies
visually, but would be enforced by MySQL at insert time.
Browse Mode
There are many ways to enter this mode. In fact, it is used each time query results are
displayed. We can enter this mode manually using the quick-browse icon on the left
panel, or by going to Table view for a specific table and clicking Browse:
First Steps
[ 76 ]
The checkboxes beside each row of results and the With selected menu
will be explained in Chapter 5.
Pages:
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95