|
If you were logged in you would be able to see more operations.
|
|
|
|
|
| Component/s: |
Core
|
| Affects Version/s: |
3.3.3,
3.4.0 Beta 1
|
| Fix Version/s: |
3.4.0 Beta 2
|
|
|
Environment:
|
MySQL 5.0.22 or later
|
|
| Support Plan Customer Issue: |
No
|
| Resolution Date: |
10/05/07 12:31 PM
|
| Acceptance Test - Add?: |
No
|
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)
);
|
|
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)
); |
Show » |
| There are no comments yet on this issue.
|
|
Bug
Closed
Major
Table entConParticipant fails to be created in MySQL when using charset utf8