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
