Bug #41583 Windows charsets are not compiled into Windows packages
Submitted: 18 Dec 2008 10:05 Modified: 16 Jan 2009 20:50
Reporter: Susanne Ebrecht Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Packaging Severity:S1 (Critical)
Version:5.0.67, 5.1.30 OS:Windows
Assigned to: CPU Architecture:Any

[18 Dec 2008 10:05] Susanne Ebrecht
Description:
I worked on bug #41511 when I figured out this:

Of course I also tried to use cp866 here but my Windows system is using codepage 850 and so I made further tests with cp850. I expect that this is the minimum that should work. Both failed on Windows and worked on Linux; cp866 and cp850.

Starting of MySQL Command Line Client failed. It just crash.

Starting MySQL manually:
mysql: Character set 'cp850' is not a compiled character set and is not specified in the 'C:\mysql\\share\charsets\Index.xml' file

It is a mess that Windows codepages don't work under Windows.

This problem only exist in Windows packages. I tried:
$ mysql --default-character-set=cp850 on Linux and there it works fine. But it won't work on Windows and Windows is the only OS where this CP<NUM> charset are really needed.

How to repeat:
Use MySQL Server Instance Config Wizzard:

Please select the default character set:

My environment is using CP850 that means I click:
Manual Select Default Character Set/Collation
and choose CP850

After finishing reconfiguring I started MySQL CLI by clicking on MySQL Command Line Client. The Window starts and crashes immediately. It disappears too fast to read error messages also it beep during crashing.

Set back configuration to Standard Character Set. Of course all work fine now again.

Now I used DOS Shell to start MySQL CLI:
> mysql --default-character-set=cp850
Character set 'cp850' is not a compiled character set and is not specified in the 'C:\mysql\\share\charsets\Index.xml' file

The only thing what works here is utf8 and latin1.

Suggested fix:
Compile the codepage charsets into the Windows packages.
[18 Dec 2008 10:11] Susanne Ebrecht
Bug #41511 is set as duplicate of this bug here. The bug is not an exakt duplicate but it is related to this bug here and only fixing this bug will help the user of 41511 and lots of other Windows users.
[16 Jan 2009 20:50] Sveta Smirnova
This is duplicate of bug #17270 really.

Workaround:

add character-sets-dir="C:/Program Files/MySQL/MySQL Server 5.0/share/charsets" to the my.ini file