Differences

This shows you the differences between two versions of the page.

--- 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 ======
-//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:
- * Mantis database must store descriptions in utf8 by default
+  * 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 =====
- * Edit the config file /etc/mysql/my.cnf
+  * Edit the config file /etc/mysql/my.cnf
-   * add to both server and client section the default encoding
+    * add to both server and client section the default encoding
    <code>
    [client]
@@ Line 173: / Line 178: @@
    default-character-set=utf8
    </code>
- * check setting in mysql command line (mysql -u root -p)
+  * check setting in mysql command line (mysql -u root -p)
-   * <code> SHOW VARIABLES LIKE 'character_set_%';</code>
+    * <code> SHOW VARIABLES LIKE 'character_set_%';</code>
 ===== Upgrade the mantis database =====
- * Upgrade 3 levels according to the book by herongyang about mySQL and php.
+  * Upgrade 3 levels according to the book by herongyang about mySQL and php.
-   * Manage mantis database by issuing following commands in mysql command line <code>mysql -u root -p mantis </code>
+    * Manage mantis database by issuing following commands in mysql command line <code>mysql -u root -p mantis </code>
-   * database level
+    * database level
-     * altering commands <code>alter database mantis character set utf8;</code>
+      * altering commands <code>alter database mantis character set utf8;</code>
-     * verify by <code>SHOW CREATE DATABASE mantis;</code>
+      * verify by <code>SHOW CREATE DATABASE mantis;</code>
-   * table and column level on mantis_bug_text_table and mantis_bugnote_text_table
+    * table and column level on mantis_bug_text_table and mantis_bugnote_text_table
-     * altering commands <code>
+      * altering commands <code>
        alter table mantis_bug_text_table default 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 convert to character set utf8;</code>
-     * verify by <code>
+      * verify by <code>
        SHOW CREATE TABLE mantis_bug_text_table;
        SHOW CREATE TABLE mantis_bugnote_text_table; </code>
 ===== 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 is displayed correctly in web browser. Tested with Firefox browser.
+ 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 are displayed correctly in web browser. Tested with Firefox browser.