Qiang Yu writes:

> This happens on my own server.
>
> Thank you, your method solves the chinese display problem in merge request
> comment.

That's great news.

> But other places like merge request title and desciption have the same
> problem. How can this be solved in all and rootly?

You should do the same to the other tables in the database as well. Open
a mysql console and enter:

alter table archived_events convert to character set utf8;
alter table backends convert to character set utf8;
alter table cloners convert to character set utf8;
alter table comments convert to character set utf8;
alter table committerships convert to character set utf8;
alter table content_memberships convert to character set utf8;
alter table emails convert to character set utf8;
alter table events convert to character set utf8;
alter table favorites convert to character set utf8;
alter table feed_items convert to character set utf8;
alter table groups convert to character set utf8;
alter table hooks convert to character set utf8;
alter table ldap_groups convert to character set utf8;
alter table memberships convert to character set utf8;
alter table merge_request_statuses convert to character set utf8;
alter table merge_request_versions convert to character set utf8;
alter table merge_requests convert to character set utf8;
alter table messages convert to character set utf8;
alter table open_id_authentication_associations convert to character set utf8;
alter table open_id_authentication_nonces convert to character set utf8;
alter table project_proposals convert to character set utf8;
alter table projects convert to character set utf8;
alter table repositories convert to character set utf8;
alter table roles convert to character set utf8;
alter table schema_migrations convert to character set utf8;
alter table sessions convert to character set utf8;
alter table sites convert to character set utf8;
alter table ssh_keys convert to character set utf8;
alter table taggings convert to character set utf8;
alter table tags convert to character set utf8;
alter table users convert to character set utf8;

Afterwards, you should set the default character set for the database:

ALTER DATABASE <DATABASE_NAME> CHARACTER SET utf8;

Cheers,
- Marius

-- 
-- 
To post to this group, send email to gitorious@googlegroups.com
To unsubscribe from this group, send email to
gitorious+unsubscr...@googlegroups.com

--- 
You received this message because you are subscribed to the Google Groups 
"Gitorious" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to gitorious+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to