Table entConParticipant fails to be created in MySQL when using charset utf8

create database openfire character set utf8;

CREATE TABLE entConParticipant (
conversationID BIGINT NOT NULL,
joinedDate BIGINT NOT NULL,
leftDate BIGINT NULL,
bareJID VARCHAR(255) NOT NULL,
jidResource VARCHAR(255) NOT NULL,
nickname VARCHAR(255) NULL,
INDEX entConParticipant_conv_idx (conversationID, bareJID, jidResource, joinedDate),
INDEX entConParticipant_jid_idx (bareJID)
);