Bug #11216 'show character set' describes latin1 incorrectly

• Submitted: 9 Jun 2005 18:22
• Modified: 5 Aug 2005 22:04
• Reporter: Sergei Golubchik
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Assigned to: Alexander Barkov
• CPU Architecture: Any

[9 Jun 2005 18:22] Sergei Golubchik

Description:
lati1 is described as "ISO 8859-1 West European", while it is in fact a superset of ISO 8859-1, known as cp1252.

Furthermore, in the manual it is called either "ISO-8859-1" or "ISO 8859-1". It is neither, it is "cp1252".  (note that "ISO-8859-1" and "ISO 8859-1" are two _different_ character sets)

How to repeat:
mysql> SHOW CHARACTER SET;

[21 Jul 2005 8:28] Alexander Barkov

Also we decided to modify conversion table for latin1:

Serg made a very nice proposal: to assign these five characters
back to controls. So our "latin1" will be a kind of mixture of
cp1252 and iso-8859-1, and will have both advantages:
- full character range provided by cp1252
- utf8 round trip safety provided by iso-8859-1

[21 Jul 2005 11:05] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/27428

[22 Jul 2005 5:23] Alexander Barkov

Reviewed by Gluh.
Pushed into 4.1.14 and 5.0.11.

[5 Aug 2005 22:04] Mike Hillyer

Documented in 4.1.14 and 5.0.11 changelogs:

<listitem><para><literal>SHOW CHARACTER SET</literal> and <literal>INFORMATION_SCHEMA</literal> now properly report the <literal>Latin1</literal> character set as <literal>cp1252</literal>. (Bug #11216)</para></listitem>

Also updated all instances of ISO-8859-1 to cp1252 in reference manual.