Bug #47462 SHOW CHARACTER SET syntax is arbitrarily inconsistent with other SHOW syntax

• Submitted: 20 Sep 2009 19:33
• Modified: 21 Sep 2009 3:26
• Reporter: Peter Brawley (Basic Quality Contributor)
• Status: Verified
• Category: MySQL Server: General
• Severity: S3 (Non-critical)
• Version: all
• OS: Any
• CPU Architecture: Any
• Tags: qc

[20 Sep 2009 19:33] Peter Brawley

Description:
SHOW DATABASES to list databases,
SHOW TABLES to list tables,
SHOW VARIABLES to list variables,
... etc but ...
SHOW CHARACTER SET to list available character sets.

Makes no sense at all, and it's annoying.

How to repeat:
As above

Suggested fix:
Allow SHOW CHARACTER SETS

[21 Sep 2009 3:26] Valeriy Kravchuk

Thank you for the problem report.