... thanx a lot.
SELECT id, surname, MAPCHAR(LOWER(surname)) AS sort FROM people ORDER BY sort
works fine for German '�' etc. and '�' -- Best -- Michael
Marcin P schrieb:
Take a look into the Docs and search for MAPCHAR. I use it for sorting with Polish (a,e,c etc.)special letters and everything works fine. However, you must remeber to add MAPCHAR clause in every query you do.
Good luck, Marcin P.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
