- Documentation Library
- Table of Contents
- MySQL 5.5 Manual
- MySQL 5.4 Manual
- MySQL 5.1 Manual
- MySQL 5.0 Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
MySQL 3.23, 4.0, 4.1 Reference Manual :: 12 SQL Statement Syntax :: 12.4 Database Administration Statements :: 12.4.5 SHOW Syntax :: 12.4.5.3 SHOW CHARACTER SET Syntax
Section Navigation [Toggle]
- 12.4.5 SHOW Syntax
- 12.4.5.1 SHOW BINARY LOGS Syntax
- 12.4.5.2 SHOW BINLOG EVENTS Syntax
- 12.4.5.3 SHOW CHARACTER SET Syntax
- 12.4.5.4 SHOW COLLATION Syntax
- 12.4.5.5 SHOW COLUMNS Syntax
- 12.4.5.6 SHOW CREATE DATABASE Syntax
- 12.4.5.7 SHOW CREATE TABLE Syntax
- 12.4.5.8 SHOW DATABASES Syntax
- 12.4.5.9 SHOW ENGINE Syntax
- 12.4.5.10 SHOW ENGINES Syntax
- 12.4.5.11 SHOW ERRORS Syntax
- 12.4.5.12 SHOW GRANTS Syntax
- 12.4.5.13 SHOW INDEX Syntax
- 12.4.5.14 SHOW INNODB STATUS Syntax
- 12.4.5.15 SHOW LOGS Syntax
- 12.4.5.16 SHOW MASTER STATUS Syntax
- 12.4.5.17 SHOW OPEN TABLES Syntax
- 12.4.5.18 SHOW PRIVILEGES Syntax
- 12.4.5.19 SHOW PROCESSLIST Syntax
- 12.4.5.20 SHOW SLAVE HOSTS Syntax
- 12.4.5.21 SHOW SLAVE STATUS Syntax
- 12.4.5.22 SHOW STATUS Syntax
- 12.4.5.23 SHOW TABLE STATUS Syntax
- 12.4.5.24 SHOW TABLES Syntax
- 12.4.5.25 SHOW VARIABLES Syntax
- 12.4.5.26 SHOW WARNINGS Syntax
SHOW CHARACTER SET [LIKE 'pattern']
The SHOW CHARACTER SET statement
shows all available character sets. It takes an optional
LIKE clause that indicates which
character set names to match. 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.
SHOW CHARACTER SET is available
as of MySQL 4.1.0.
User Comments
Add your own comment.