A proper choice of collation is important for obtaining the intended results when
searching data, for example from phpMyAdmin's Search page, and also when
sorting data.
For an introduction to collations, see http://dev.mysql.com/doc/mysql/en/
Charset-general.htm, and for a more technical explanation of the algorithms
involved, refer to http://www.unicode.org/reports/tr10/.
Chapter 17
[ 259 ]
The Home Page
Here is what the Home page looks like, when connecting to a MySQL 4.1.x or later
server (the sections that follow detail the changes):
Creating a Database
When creating a database, we can choose its default character set and collation
with the Collation dialog. This setting can be changed later. (See the section The
Database View.)
Character Sets and Collations
[ 260 ]
Available Character Sets and Collations
The Character Sets and Collations link on the Home page opens the Server view
for the Charsets sub-page, which lists the character sets and collations supported
by the MySQL server. The default collation for each character set is shown with
a different background color (using the row-marking color defined in
$cfg['BrowseMarkerColor']):
Effective Character Sets and Collations
phpMyAdmin picks the 'effective' character set??”the one that best fits our selected
language (which obviously is the one we want to see in our browser).
Pages:
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239