Bug #28160 wrong default encoding for system tables in documentation

• Submitted: 30 Apr 2007 9:23
• Modified: 2 May 2007 0:53
• Reporter: Susanne Ebrecht
• Status: Not a Bug
• Category: MySQL Server: Documentation
• Severity: S2 (Serious)
• Version: 5.1 maybe 5.0, too
• OS: Any
• Assigned to: Paul DuBois
• CPU Architecture: Any

[30 Apr 2007 9:23] Susanne Ebrecht

Description:
Hi All,

http://dev.mysql.com/doc/refman/5.1/en/configure-options.html
http://dev.mysql.com/doc/refman/5.1/de/configure-options.html

I first found it, at the German version, but it's at the English version, too.

Text:
"By default, MySQL uses the latin1 (cp1252 West European) character set. To change the default set, use the --with-charset option:"

Since version 5.0 the default is utf8 instead of latin1 (support told me).

Text:
"The default collation may also be specified. MySQL uses the latin1_swedish_ci collation by default. To change this, use the --with-collation  option:"

That is also not true for version 5.1, I figured out, it's mixed. I didn't look to all system tables. At the table user, the collate is utf8 (besides password column).

At the system table user the column password is latin1 with latin1 encoding (maybe a bug, too). I didn't look in all system tables.

Regards,

Susanne

How to repeat:
Just install mysql to figure out, what is the default charset and collation.

[2 May 2007 0:53] Paul DuBois

The default character set and collation of the server
has nothing to do with the encoding used for the
system tables.  Those tables do indeed use utf8,
but that's a separate issue.