Detailed analysis: teach you to master the table character set and proofreading

Each table has a table character set and a proof rule, it can not be empty. To specify the character set and collation table, CREATE TABLE and ALTER TABLE statement has an optional clause:

CREATE TABLE tbl_name (column_list)

[DEFAULT CHARACTER SET charset_name [COLLATE collation_name]]

ALTER TABLE tbl_name

[DEFAULT CHARACTER SET charset_name] [COLLATE collation_name]

For example:

CREATE TABLE t1 (...)

DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci;

Select MySQL in the following way table character set and collation:

* If you specify a CHARACTER SET X and COLLATE Y, then the use of CHARACTER SET X and COLLATE Y.

If specified, do not specify CHARACTER SET X and COLLATE Y, then the use of CHARACTER SET X and CHARACTER SET X the default collation.

* Otherwise, use the server character set and server collation.

If the definition is not specified in the column character set and collation column, then the default table character set and collation. Table character set and collation are MySQL extensions; in standard SQL, no.







Recommended links:



3G2 to WMV



3G2 To AVI



RMVB to MPEG



how to transfer music movie from iphone to