charset latin1_de: several problems and questions

2001-10-18 Thread Matthias Ragaz
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

character set latin1_de : several questions

2001-10-18 Thread Matthias Ragaz
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 ------

Re: Re: Question about left join.

2001-10-24 Thread Matthias Ragaz
; >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