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

Description

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)
);

Environment

MySQL 5.0.22 or later

Fixed
Your pinned fields
Click on the next to a field label to start pinning.

Assignee

Gaston Dombiak

Reporter

Gaston Dombiak