Character Sets and Collations
[ 262 ]
The Table View
We can use the Table view's Operations sub-page to change the default character set
and collation information for a table:
We can also use the Table view's Structure sub-page to choose the character set
for a column, by clicking the Change link for this column:
Chapter 17
[ 263 ]
Importing and Exporting with Character Sets
When exporting results, we can see the default character set and collation
information for the table and its columns:
CREATE TABLE IF NOT EXISTS `author` (
`id` int(11) NOT NULL,
`name` varchar(30) character set latin1 collate latin1_general_ci
NOT NULL,
`phone` varchar(30) default NULL,
`country_code` char(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Here, we have changed the collation of the name column to latin1_general_ci;
therefore, it is shown in the export results??”because this collation is different to the
table's default collation.
Server View
In the Server view, we can obtain statistics about the databases. (See the Database
Information section in Chapter 19.) If our server supports character sets and collations,
we will see an additional information column, Collation, on this page:
Kanji Support
If phpMyAdmin detects usage of the Japanese language, it checks whether PHP
supports the mb_convert_encoding() multi-byte strings function.
Pages:
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241