http://www.wpwp.org/forums/topic/missing-default-charset-in-create-table WassUp Forums » Topic: Missing "DEFAULT CHARSET" in "CREATE TABLE" en-US Sat, 11 Feb 2012 00:40:55 +0000 http://bbpress.org/?v=1.0.3 q http://www.wpwp.org/forums/search.php http://www.wpwp.org/forums/topic/missing-default-charset-in-create-table#post-360 Fri, 18 Apr 2008 15:03:24 +0000 Michele 360@http://www.wpwp.org/forums/ <p>Thank you very much! I will merge it as soon as possible </p> http://www.wpwp.org/forums/topic/missing-default-charset-in-create-table#post-359 Fri, 18 Apr 2008 14:41:45 +0000 sandajian 359@http://www.wpwp.org/forums/ <p>I installed wassup trunk 129 in my blog <a href="http://zh.linuxforfun.net/" rel="nofollow">http://zh.linuxforfun.net/</a>, which is in Chinese. The default charset of the blog is set to 'UTF-8' . In the wassup page, all Chinese characters in 'KEYWORDS:' are displayed as question marks (?). I examined the database and found that the table 'wp_zh_linuxforfun_net_wassup' used the charset 'latin1' as its charset, but Wordpress uses 'UTF-8' as the default charset of all tables.</p> <p>I edited wassup.php, adding some lines to specify 'DEFAULT CHARSET' of tables in 'CreateTable()'. After that, Chinese characters in 'KEYWORDS' were displayed correctly.</p> <p>The Patch is shown below:<br /> <pre><code>--- wassup.php.sav 2008-04-09 08:24:30.000000000 -0700 +++ wassup.php 2008-04-18 06:21:27.000000000 -0700 @@ -1098,6 +1098,13 @@ function CreateTable($tablename=&quot;wassup&quot;) { global $wpdb; + $charset_collate = &#39;&#39;; + if ( $wpdb-&gt;supports_collation() ) { + if ( ! empty($wpdb-&gt;charset) ) + $charset_collate = &quot;DEFAULT CHARACTER SET $wpdb-&gt;charset&quot;; + if ( ! empty($wpdb-&gt;collate) ) + $charset_collate .= &quot; COLLATE $wpdb-&gt;collate&quot;; + } $table_name = $wpdb-&gt;prefix . $tablename; $sql_createtable = &quot;CREATE TABLE &quot; . $table_name . &quot; ( id mediumint(9) NOT NULL auto_increment, @@ -1123,7 +1130,7 @@ UNIQUE KEY id (id), KEY wassup_id (wassup_id), INDEX (timestamp) -);&quot;; +) $charset_collate;&quot;; require_once( ABSPATH.&#39;wp-admin/upgrade-functions.php&#39;); dbDelta($sql_createtable); } //end function createTable</code></pre>