-
Notifications
You must be signed in to change notification settings - Fork 15
Turn your MySQL DB to utf8
alter database openfire charset=utf8;
alter table ofUser charset=utf8;
ALTER TABLE ofUser CONVERT TO CHARACTER SET utf8;
alter table ofUser change name name VARCHAR(100) character set utf8;
alter table AtomPerson charset=utf8;
ALTER TABLE AtomPerson CONVERT TO CHARACTER SET utf8;
alter table AtomPerson change name name VARCHAR(255) character set utf8;
alter table FullNameField charset=utf8;
ALTER TABLE FullNameField CONVERT TO CHARACTER SET utf8;
alter table FullNameField change fullName fullName VARCHAR(255) character set utf8;
alter table NameField charset=utf8;
ALTER TABLE NameField CONVERT TO CHARACTER SET utf8;
alter table NameField change given given VARCHAR(255) character set utf8;
alter table NameField change surname surname VARCHAR(255) character set utf8;
alter table NameField change prefix prefix VARCHAR(255) character set utf8;
alter table NameField change suffix suffix VARCHAR(255) character set utf8;
alter table NoteField charset=utf8;
ALTER TABLE NoteField CONVERT TO CHARACTER SET utf8;
alter table NoteField change note note VARCHAR(255) character set utf8;
alter table Activities charset=utf8;
ALTER TABLE Activities CONVERT TO CHARACTER SET utf8;
alter table Activities change title title VARCHAR(255) character set utf8;
alter table AtomContent charset=utf8;
ALTER TABLE AtomContent CONVERT TO CHARACTER SET utf8;
alter table AtomContent change value value VARCHAR(255) character set utf8;
alter table AtomEntry charset=utf8;
ALTER TABLE AtomEntry CONVERT TO CHARACTER SET utf8;
alter table AtomEntry change title title VARCHAR(255) character set utf8;
alter table Objects charset=utf8;
ALTER TABLE Objects CONVERT TO CHARACTER SET utf8;
alter table Objects change title title VARCHAR(255) character set utf8;
alter table Relation charset=utf8;
ALTER TABLE Relation CONVERT TO CHARACTER SET utf8;
alter table Relation change comment comment VARCHAR(255) character set utf8;
alter table Relation change guid guid VARCHAR(255) character set utf8;
alter table Relation change nature nature VARCHAR(255) character set utf8;
alter table Relation change origin origin VARCHAR(255) character set utf8;
alter table Relation change owner owner VARCHAR(255) character set utf8;
alter table Relation change status status VARCHAR(255) character set utf8;
alter table Relation change target target VARCHAR(255) character set utf8;