Hello, i installed mysql-max-4.
i need use czech sorting - i set [mysqld] default-character-set=czech but create table xx (t varchar(10)); insert into xx values('a'); insert into xx values('c'); insert into xx values('t'); insert into xx values('s'); insert into xx values('b'); insert into xx values('d'); select * from xx order by t; +------+ | t | +------+ | a | | b | | c | | d | | s | | t | +------+ insert into xx values('è'); (è is c with grave accent) in czech language is è after c select * from xx order by t; +------+ | t | +------+ | è | <-- bad | a | | b | | c | <-- must be after this letter. | d | | s | | t | +------+ So where is problem.... ????? when trying set win1250 charset i got (setting charset to latin 2 produce is same problem): C:\Program Files\mysql\bin\mysql.exe: File 'C:\mysql\\share\charsets\?.conf' not found (Errcode: 2) C:\Program Files\mysql\bin\mysql.exe: Character set '#26' is not a compiled character set and is not specified in the 'C:\mysql\\share\charsets\Index' file C:\mysql\\share\ -- this path is invalid!!! in my.ini i set: basedir=C:/Program Files/mysql datadir=C:/Program Files/mysql/data language=C:/Program Files/mysql/share/czech character-sets-dir=C:/Program Files/mysql/share/charsets default-character-set=win1250 skip-innodb Michal table, sql, database --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php