Bug #11216 'show character set' describes latin1 incorrectly
Submitted: 9 Jun 2005 20:22 Modified: 6 Aug 2005 0:04
Reporter: Sergei Golubchik
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version: OS:
Assigned to: Alexander Barkov Target Version:

[9 Jun 2005 20: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 10: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 13: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 7:23] Alexander Barkov 
Reviewed by Gluh.
Pushed into 4.1.14 and 5.0.11.
[6 Aug 2005 0: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.