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: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 4.1.2 | OS: | Windows (win2000) |
Assigned to: | CPU Architecture: | Any |
[5 Jun 2004 22:12]
Csaba Szolga
[6 Jun 2004 2:02]
MySQL Verification Team
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...
[6 Jun 2004 10:42]
Csaba Szolga
I atached an test database, which cause an error.
[6 Jun 2004 17:09]
MySQL Verification Team
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>
[7 Jun 2004 11:24]
Sergei Golubchik
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"
[8 Jun 2004 11:17]
Csaba Szolga
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.
[8 Jun 2004 13:36]
Sergei Golubchik
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)