MySQL Bugs: #4020: Character set '#9' is not a compiled character set

Bug #4020	Character set '#9' is not a compiled character set
Submitted:	5 Jun 2004 22:12	Modified:	8 Jun 2004 13:36
Reporter:	Csaba Szolga	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.1.2	OS:	Windows (win2000)
Assigned to:		CPU Architecture:	Any

Description:
I'm using latin2 charset.
When I run mysqlcheck I got to following error:

error    : Character set '#9' is not a compiled character set and is not specified in the 'C:\mysql\share\charsets\Index.xml' file

How to repeat:
mysqlcheck.exe --check -v --auto-repair --all-databases

C:\mysql\bin>mysqlcheck.exe --check -v --auto-repair --all-databases --default-character-set=latin2
# Connecting to localhost...
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.func                                         OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.tables_priv                                  OK
mysql.user                                         OK
test.mytest                                        OK
# Disconnecting from localhost...

I atached an test database, which cause an error.

I added the database agenda which you attached and still
I can't repeat the behavior reported:

C:\mysql\bin>mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.2-alpha-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "%character%";
+--------------------------+--------------------------+
| Variable_name            | Value                    |
+--------------------------+--------------------------+
| character_set_client     | latin2                   |
| character_set_connection | latin2                   |
| character_set_database   | latin2                   |
| character_set_results    | latin2                   |
| character_set_server     | latin2                   |
| character_set_system     | utf8                     |
| character_sets_dir       | c:\mysql\share\charsets/ |
+--------------------------+--------------------------+
7 rows in set (0.01 sec)

mysql> exit
Bye

C:\mysql\bin>mysqlcheck.exe --check -v --auto-repair --all-databases
# Connecting to localhost...
agenda.faj                                         OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.func                                         OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.tables_priv                                  OK
mysql.user                                         OK
test.mytest                                        OK
# Disconnecting from localhost...

C:\mysql\bin>

Please, check whether there is really such a file - C:\mysql\share\charsets\Index.xml
and whether it, indeed, contains an entry with id="9"

My index file has no extension.
But it exist and it contains (latin2 9)
the situation is same if I rename it to index.xml.

I can not run MySQL as a service if c:\my.cnf contains
[mysqld]
default-character-set=latin2

I got the following error message:
Could not start the MySQL service on Local Computer.
Error 1067: The process terminated unexpectedly

If I comment out that line service run with latin1.

I used 4.0.x series with default-character-set=latin2 previously.

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

on upgrading from 4.0 you cannot replace the server binary *only*. You also need at least share/ directory from 4.1 - in charset/ subdir it includes Index.xml, and xml files for each charset (e.g. latin2.xml)