How to sort results with german umlauts in a UTF8 MySQL Database

Hi there, I have a MySQL 4.1 DB running including a database whose character set is set to utf8. In the database I have a table "tblmembers" with some records containing german umlauts. How do I sort results with german umlauts if the database character set is set to utf8? Using the SQL query S

Sorting results ith umlauts in UTF8 tables

Hi there, I am running MySQL 4.1 on Linux. I have some problems sorting records with german umlauts. MySQL is configured to have character set "UTF8" as default. I have created a table like this: CREATE TABLE tblmembers ( memberid int(11) NOT NULL auto_increment, lastname varchar(255) NOT N