Über Google gefunden in den HostEurope-FAQ:

SELECT utf8_spalte FROM tabelle	ORDER BY CONVERT(utf8_spalte USING utf8) 	COLLATE utf8_german2_ci ASC;