We're updating the issue view to help you get more done. 

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

Acceptance Test - Entry

None

Assignee

Gaston Dombiak

Reporter

Gaston Dombiak

Labels

None

Expected Effort

None

Ignite Forum URL

None

Components

Fix versions

Affects versions

Priority

Major
Configure