Re: Re: Question about left join.

2001-10-24 Thread Matthias Ragaz
details as d where u.disabled='N' and d.entrydate date_add(now(), interval -7 day ) group by u.username order by 2 desc Who Logs --- bob 7 sarah 3 frank 1 Matthias Ragaz Informatik - Entwicklung Schweizerische Bibliothek für Blinde und Sehbehinderte

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
: 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 -- Matthias Ragaz Informatik - Entwicklung Schweizerische