gerrit是怎么使用MySQL_解决Gerrit2使用mysql时中文乱码问题

主要问题出在数据库上&＃xff0c;为了保证安装时不出问题使用了latin1&＃xff0c;但使用过程中就出现中文乱码问题了&＃xff0c;

有时在报错如&＃xff1a;

java.sql.BatchUpdateException: Incorrect string value: &＃39;\xC9\xCF&＃39;

for column &＃39;message&＃39; at row 1

或

Illegal mix of collations (latin1_bin,IMPLICIT) and

(utf8_general_ci,COERCIBLE) for operation &＃39;<&＃61;&＃39;

为此&＃xff0c;修改如下

vi /etc/my.cnf

[mysqld]

default-character-set&＃61;utf8

init_connect&＃61;&＃39;SET NAMES utf8&＃39;

[client]

default-character-set&＃61;utf8

进入数据库mysql>,执行如下命令

ALTER DATABASE gitdb charset&＃61;utf8;

alter table account_diff_preferences

engine&＃61;innodb;

alter table account_external_ids engine&＃61;innodb;

alter table account_group_id engine&＃61;innodb;

alter table account_group_includes_by_uuid

engine&＃61;innodb;

alter table account_group_includes_by_uuid_audit

engine&＃61;innodb;

alter table account_group_members engine&＃61;innodb;

alter table account_group_members_audit

engine&＃61;innodb;

alter table account_group_names engine&＃61;innodb;

alter table account_groups engine&＃61;innodb;

alter table account_id engine&＃61;innodb;

alter table account_patch_reviews engine&＃61;innodb;

alter table account_project_watches engine&＃61;innodb;

alter table account_ssh_keys engine&＃61;innodb;

alter table accounts engine&＃61;innodb;

alter table change_id engine&＃61;innodb;

alter table change_message_id engine&＃61;innodb;

alter table change_messages engine&＃61;innodb;

alter table changes engine&＃61;innodb;

alter table patch_comments engine&＃61;innodb;

alter table patch_set_ancestors engine&＃61;innodb;

alter table patch_set_approvals engine&＃61;innodb;

alter table patch_sets engine&＃61;innodb;

alter table schema_version engine&＃61;innodb;

alter table starred_changes engine&＃61;innodb;

alter table submodule_subscriptions engine&＃61;innodb;

alter table system_config engine&＃61;innodb;

alter table tracking_ids engine&＃61;innodb;

ALTER TABLE account_diff_preferences CONVERT TO CHARACTER SET utf8

COLLATE utf8_general_ci;

ALTER TABLE account_external_ids CONVERT TO CHARACTER SET utf8

COLLATE utf8_general_ci;

ALTER TABLE account_group_id CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

ALTER TABLE account_group_includes_by_uuid CONVERT TO CHARACTER SET

utf8 COLLATE utf8_general_ci;

ALTER TABLE account_group_includes_by_uuid_audit CONVERT TO

CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE account_group_members CONVERT TO CHARACTER SET utf8

COLLATE utf8_general_ci;

ALTER TABLE account_group_members_audit CONVERT TO CHARACTER SET

utf8 COLLATE utf8_general_ci;

ALTER TABLE account_group_names CONVERT TO CHARACTER SET utf8

COLLATE utf8_general_ci;

ALTER TABLE account_groups CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

ALTER TABLE account_id CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

ALTER TABLE account_patch_reviews CONVERT TO CHARACTER SET utf8

COLLATE utf8_general_ci;

ALTER TABLE account_project_watches CONVERT TO CHARACTER SET utf8

COLLATE utf8_general_ci;

ALTER TABLE account_ssh_keys CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

ALTER TABLE accounts CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

ALTER TABLE change_id CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

ALTER TABLE change_message_id CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

ALTER TABLE change_messages CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

ALTER TABLE changes CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

ALTER TABLE patch_comments CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

ALTER TABLE patch_set_ancestors CONVERT TO CHARACTER SET utf8

COLLATE utf8_general_ci;

ALTER TABLE patch_set_approvals CONVERT TO CHARACTER SET utf8

COLLATE utf8_general_ci;

ALTER TABLE patch_sets CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

ALTER TABLE schema_version CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

ALTER TABLE starred_changes CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

ALTER TABLE submodule_subscriptions CONVERT TO CHARACTER SET utf8

COLLATE utf8_general_ci;

ALTER TABLE system_config CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

ALTER TABLE tracking_ids CONVERT TO CHARACTER SET utf8 COLLATE

utf8_general_ci;

目的就是保证都使用utf8编码&＃xff0c;引擎使用innodb&＃xff0c;目的就是为了保证索引长度大于1000时依然不出错。