Description:
I setup MySQL 5.0.18 on a Windows 2000 SP4 machine.
I used "mysql-essential-5.0.18-win32.msi" installer package for installation. I configured character set to latin5 (with MySQL Server Instance Config Wizard). Server started without any problem but when I try to use "mysql" command line tool I saw following error message and mysql client could not start;
mysql: Character set 'latin5' is not a compiled character set and is not specified in the 'C:\mysql\\share\charsets\Index.xml' file
After this error I add following line(character-sets-dir) into my.ini file and now it is working.
# CLIENT SECTION
...
[mysql]
default-character-set=latin5
character-sets-dir="C:/Program Files/MySQL/MySQL Server 5.0/share/charsets"
I think this is a bug of "MySQL Server Instance Config Wizard" tool.
Mr.Sea
mrsea77@yahoo.com
How to repeat:
Install mysql server and set character set to latin5 during config wizard. After installation try to use mysql tool with this command;
C:\>mysql -u root -p
mysql: Character set 'latin5' is not a compiled character set and is not specified in the 'C:\mysql\\share\charsets\Index.xml' file
Suggested fix:
After this error I add following line (character-sets-dir) into my.ini file and now it is working.
# CLIENT SECTION
...
[mysql]
default-character-set=latin5
character-sets-dir="C:/Program Files/MySQL/MySQL Server 5.0/share/charsets"