mantisbt:upgrade_to_utf8
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
mantisbt:upgrade_to_utf8 [2009/12/05 03:26] – tomyjwu | mantisbt:upgrade_to_utf8 [2013/06/10 12:18] (current) – atrol | ||
---|---|---|---|
Line 153: | Line 153: | ||
====== Enable CJK Text Entering ====== | ====== Enable CJK Text Entering ====== | ||
- | //additional notes by tomyjwu// | + | **additional notes by tomyjwu** |
- | This hack and experience is done in ubuntu 8.04 with mantis 1.1.2+dfsg-8~hardy1. | + | ===== Introduction ===== |
+ | |||
+ | This hack and experience is done in ubuntu 8.04 with | ||
+ | * mantis 1.1.2+dfsg-8~hardy1 | ||
+ | * mysql 5.0.51a-3ubuntu5.4 | ||
The goal is to enable CJK text input on mantis bug descriptions and notes. Two issues must be resolved: | The goal is to enable CJK text input on mantis bug descriptions and notes. Two issues must be resolved: | ||
- | * Mantis database must store descriptions in utf8 by default | + | |
- | * Mantis communicates with mySQL using utf8 way, according to the book by herongyang. | + | * Mantis communicates with mySQL using utf8 way, according to the book by herongyang |
- | * See Web resources section for the book URL. | + | |
+ | Please check the Web resources section for the book URL. | ||
===== Enable utf8 communications ===== | ===== Enable utf8 communications ===== | ||
- | * Edit the config file / | + | |
- | | + | * add to both server and client section the default encoding |
< | < | ||
| | ||
Line 173: | Line 178: | ||
| | ||
</ | </ | ||
- | * check setting in mysql command line (mysql -u root -p) | + | |
- | | + | * < |
===== Upgrade the mantis database ===== | ===== Upgrade the mantis database ===== | ||
- | * Upgrade 3 levels according to the book by herongyang about mySQL and php. | + | |
- | | + | * Manage mantis database by issuing following commands in mysql command line < |
- | | + | * database level |
- | | + | * altering commands < |
- | | + | * verify by < |
- | | + | * table and column level on mantis_bug_text_table and mantis_bugnote_text_table |
- | | + | * altering commands < |
alter table mantis_bug_text_table default character set utf8; | alter table mantis_bug_text_table default character set utf8; | ||
alter table mantis_bug_text_table convert to character set utf8; | alter table mantis_bug_text_table convert to character set utf8; | ||
alter table mantis_bugnote_text_table default character set utf8; | alter table mantis_bugnote_text_table default character set utf8; | ||
alter table mantis_bugnote_text_table convert to character set utf8;</ | alter table mantis_bugnote_text_table convert to character set utf8;</ | ||
- | * verify by < | + | |
SHOW CREATE TABLE mantis_bug_text_table; | SHOW CREATE TABLE mantis_bug_text_table; | ||
SHOW CREATE TABLE mantis_bugnote_text_table; | SHOW CREATE TABLE mantis_bugnote_text_table; | ||
===== Results ===== | ===== Results ===== | ||
- | Now you could add a new bug entry in the mantis using web interface and preserve the entered CJK text in utf8 format. Resulted entries | + | Now you could add a new bug entry in the mantis using web interface and preserve the entered CJK text in utf8 format. Resulted entries |
mantisbt/upgrade_to_utf8.1260001564.txt.gz · Last modified: 2009/12/05 03:34 (external edit)