character sets (latin5) on v5.0.0-alpha

[Tolga Ozdemirel]

Hi,

Using Mysql Server 5.0.0-alpha on WinXP. The problem is the sort order in mysql server
with latin5 char set. I think it is also the problem with latin2 and other languages
(except show character set results).

there is latin5.conf in mysqldir/share/charsets and there is a record latin5 with id 30 in
the index file.

if i add the defult-character-set=latin5 in the my.ini file the server(as a service)
couldn't start. i also tried file rename (latin5.conf as latin1.conf) but nothing
changed. I also tried to force with character-sets-dir= mysqldir/share/charsets in
my.ini.

if i tried to add a table with sql i got this error:
CREATE TABLE MYTABLE (
firstfield int(3) NOT NULL,
secondfield varchar(50) NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin5;
result was:
ERROR 1115 (42000): Unknown character set: 'latin5'

if i tried with mysqlcheck;
mysqlcheck --all-databases --default-character-set=latin5
result was:
"mysqlcheck: Character set 'latin5' is not a compiled character set and is not specified
in the 'C:\mysql\\share\charsets\Index.xml' file"
my mysql dir is not c:\mysql and filename is not index.xml (I think it is inherited by
v4). 

on the other hand "show character set" result is:
big5;;big5_chinese_ci;2;
latin1;;latin1_swedish_ci;1;
ujis;;ujis_japanese_ci;3;
sjis;;sjis_japanese_ci;2;
tis620;;tis620_thai_ci;1;
euckr;;euckr_korean_ci;2;
gb2312;;gb2312_chinese_ci;2;
gbk;;gbk_chinese_ci;2;
utf8;;utf8_general_ci;3;
ucs2;;ucs2_general_ci;2;
binary;;binary;1;

I guess it's not a bug but how can we solve this? 

ps: It appears that there is a problem with v4 too. http://lists.mysql.com/win32/14741

Tolga Ozdemirel