Hi
I have installed mysql 4.0 from source, configured with
./configure \
--with-charset=latin1_de
--
Matthias Ragaz
Informatik - Entwicklung
Schweizerische Bibliothek für Blinde und Sehbehinderte
Albisriederstasse 399
CH-8047 Zürich
little simplified).
An example makes it clearer:
bar
Bär
Bären
Barenboim
bärtig
The character U+00DF (ß) is treated like two letters 's' but her it comes
_before_ 'ss'
if everything else is identical.
Sincerely
Matthias
------
; >from users as u natural left join details as d
> >where u.disabled='N'
> >and d.entrydate > date_add(now(), interval -7 day )
> >group by u.username
> >order