For example,
we will see the following on the Home page:
The character set information (as seen here after MySQL charset) is passed to
the MySQL server. MySQL then transforms the characters that will be sent to our
browser into this character set. MySQL also interprets what it receives from the
browser according to the character set information. Remember that all tables and
fields have a character set information describing how their data is encoded.
We can also choose which character set and collation will be used for our connection
to the MySQL server using the MySQL connection collation dialog. Normally, the
default value should work, but if we are entering some characters using a different
character set, we can choose the proper character set in this dialog.
Chapter 17
[ 261 ]
The following parameter defines the default connection collation:
$cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci';
The Database View
We can also use the Database view's Operations sub-page to change the default
character set for the database:
We can see the collation used for each table on the Structure page for the database:
On the Sum line, it makes sense to display the total number of records and the total
size, but the Collation information is not a "total collation"; phpMyAdmin uses this
space to display the default collation for the current database, as can be seen by
hovering over this collation name.
Pages:
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240