Brilliant

Das half bei uns.

ALTER TABLE "mdl_user" ALTER COLUMN "lastname" TYPE varchar(100) COLLATE "de_CH.utf8";
ALTER TABLE "mdl_user" ALTER COLUMN "firstname" TYPE varchar(100) COLLATE "de_CH.utf8";
REINDEX INDEX "moodle27_mdl_user_lastname8_idx";

Herzliche Grüsse

Luca