Skip navigation links
MySQL 5.0 Reference Manual :: 18 INFORMATION_SCHEMA Tables :: 18.1 The INFORMATION_SCHEMA CHARACTER_SETS Table
18.2 The INFORMATION_SCHEMA COLLATIONS Table »
Section Navigation      [Toggle]

18.1. The INFORMATION_SCHEMA CHARACTER_SETS Table

The CHARACTER_SETS table provides information about available character sets.

INFORMATION_SCHEMA Name SHOW Name Remarks
CHARACTER_SET_NAME Charset  
DEFAULT_COLLATE_NAME Default collation  
DESCRIPTION Description MySQL extension
MAXLEN Maxlen MySQL extension

The following statements are equivalent: 

SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS
  [WHERE CHARACTER_SET_NAME LIKE 'wild']

SHOW CHARACTER SET
  [LIKE 'wild']
Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices