Re: [gitorious] Gitorious merge request chinese support problem
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.
Re: [gitorious] Gitorious merge request chinese support problem
Qiang Yu writes: Thank you very much. Now chinese can be displayed correctly on my server. (sorry, just had to...) - 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.
Re: [gitorious] Gitorious merge request chinese support problem
Qiang Yu writes: I have chinese language support problem in gitorious. When type in comments in chinese in the gitorious merge request page, the content will be displayed in after submit. Does gitoriouse support chinese? How can I fix this? Huh, I'm a little surprised this hasn't come up yet. This appears to be caused by a mismatch between the character set specified in your database.yml and the character set in your mysql tables. I just did the following in my local Gitorious installation: - Comment on a merge request entering the unicode symbol U+2665 (♥). This was rendered as a ? character in the UI. The default character set for the comments table in my database was latin1 and my database.yml specified utf8 as the character set - In a mysql console I entered alter table comments convert to character set utf8. This converts the table, both existing data and future rows inserted - Again, I entered the same Unicode character in a merge request comment, and it rendered as expected I'm assuming UTF-8 would be the best character set for Chinese, so that would probably be the safest bet. Is this happening on your own server, or on gitorious.org? 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.
Re: [gitorious] Gitorious merge request chinese support problem
This happens on my own server. Thank you, your method solves the chinese display problem in merge request comment. But other places like merge request title and desciption have the same problem. How can this be solved in all and rootly? On Wed, Apr 17, 2013 at 5:00 PM, Marius Mårnes Mathiesen marius.mathie...@gmail.com wrote: Qiang Yu writes: I have chinese language support problem in gitorious. When type in comments in chinese in the gitorious merge request page, the content will be displayed in after submit. Does gitoriouse support chinese? How can I fix this? Huh, I'm a little surprised this hasn't come up yet. This appears to be caused by a mismatch between the character set specified in your database.yml and the character set in your mysql tables. I just did the following in my local Gitorious installation: - Comment on a merge request entering the unicode symbol U+2665 (♥). This was rendered as a ? character in the UI. The default character set for the comments table in my database was latin1 and my database.yml specified utf8 as the character set - In a mysql console I entered alter table comments convert to character set utf8. This converts the table, both existing data and future rows inserted - Again, I entered the same Unicode character in a merge request comment, and it rendered as expected I'm assuming UTF-8 would be the best character set for Chinese, so that would probably be the safest bet. Is this happening on your own server, or on gitorious.org? 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.
