Bug #11216 'show character set' describes latin1 incorrectly

Submitted:	9 Jun 2005 18:22	Modified:	5 Aug 2005 22:04
Reporter:	Sergei Golubchik	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:		OS:
Assigned to:	Alexander Barkov	CPU Architecture:	Any

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;

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

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

Reviewed by Gluh.
Pushed into 4.1.14 and 5.0.11.

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.

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.