SHOW
Syntax
1175
and analysis. See
Section 4.6.7, “
mysqlbinlog
— Utility for Processing Binary
Log Files”
.
Note
Some events relating to the setting of user and system variables are not
included in the output from
SHOW BINLOG EVENTS
. To get complete coverage
of events within a binary log, use
mysqlbinlog
.
13.7.5.3.
SHOW CHARACTER SET
Syntax
SHOW CHARACTER SET
[LIKE '
pattern
' | WHERE
expr
]
The
SHOW CHARACTER SET
statement shows all available character sets. The
LIKE
[896]
clause, if
present, indicates which character set names to match. The
WHERE
clause can be given to select rows
using more general conditions, as discussed in
Section 19.18, “Extensions to
SHOW
Statements”
. For
example:
mysql>
SHOW CHARACTER SET LIKE 'latin%';
+---------+-----------------------------+-------------------+--------+
| Charset | Description | Default collation | Maxlen |
+---------+-----------------------------+-------------------+--------+
| latin1 | cp1252 West European | latin1_swedish_ci | 1 |
| latin2 | ISO 8859-2 Central European | latin2_general_ci | 1 |
| latin5 | ISO 8859-9 Turkish | latin5_turkish_ci | 1 |
| latin7 | ISO 8859-13 Baltic | latin7_general_ci | 1 |
+---------+-----------------------------+-------------------+--------+
The
Maxlen
column shows the maximum number of bytes required to store one character.
13.7.5.4.
SHOW COLLATION
Syntax
SHOW COLLATION
[LIKE '
pattern
' | WHERE
expr
]
This statement lists collations supported by the server. By default, the output from
SHOW COLLATION
includes all available collations. The
LIKE
[896]
clause, if present, indicates which collation names to
match. The
WHERE
clause can be given to select rows using more general conditions, as discussed in
Section 19.18, “Extensions to
SHOW
Statements”
. For example:
mysql>
SHOW COLLATION LIKE 'latin1%';
+-------------------+---------+----+---------+----------+---------+
| Collation | Charset | Id | Default | Compiled | Sortlen |
+-------------------+---------+----+---------+----------+---------+
| latin1_german1_ci | latin1 | 5 | | | 0 |
| latin1_swedish_ci | latin1 | 8 | Yes | Yes | 0 |
| latin1_danish_ci | latin1 | 15 | | | 0 |
| latin1_german2_ci | latin1 | 31 | | Yes | 2 |
| latin1_bin | latin1 | 47 | | Yes | 0 |
| latin1_general_ci | latin1 | 48 | | | 0 |
| latin1_general_cs | latin1 | 49 | | | 0 |
| latin1_spanish_ci | latin1 | 94 | | | 0 |
+-------------------+---------+----+---------+----------+---------+
The
Collation
and
Charset
columns indicate the names of the collation and the character set with
which it is associated.
Id
is the collation ID.
Default
indicates whether the collation is the default for
its character set.
Compiled
indicates whether the character set is compiled into the server.
Sortlen
is related to the amount of memory required to sort strings expressed in the character set.
To see the default collation for each character set, use the following statement.
Default
is a reserved
word, so to use it as an identifier, it must be quoted as such:
mysql>
SHOW COLLATION WHERE `Default` = 'Yes';
+---------------------+----------+----+---------+----------+---------+
| Collation | Charset | Id | Default | Compiled | Sortlen |
Summary of Contents for 5.0
Page 1: ...MySQL 5 0 Reference Manual ...
Page 18: ...xviii ...
Page 60: ...40 ...
Page 396: ...376 ...
Page 578: ...558 ...
Page 636: ...616 ...
Page 844: ...824 ...
Page 1234: ...1214 ...
Page 1427: ...MySQL Proxy Scripting 1407 ...
Page 1734: ...1714 ...
Page 1752: ...1732 ...
Page 1783: ...Configuring Connector ODBC 1763 ...
Page 1793: ...Connector ODBC Examples 1773 ...
Page 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Page 2850: ...2830 ...
Page 2854: ...2834 ...
Page 2928: ...2908 ...
Page 3000: ...2980 ...
Page 3122: ...3102 ...
Page 3126: ...3106 ...
Page 3174: ...3154 ...
Page 3232: ...3212 ...
