Thank you very much. Now chinese can be displayed correctly on my server.
On Thu, Apr 18, 2013 at 3:38 PM, Marius Mårnes Mathiesen < marius.mathie...@gmail.com> wrote: > > 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. > > > -- -- 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.