Blog Software

This is a translated version of http://www.drupalcenter.de/node/852 by Yahoo.

The document describes how to use OSWD (Open Source Web Design) themes in Drupal. 

There are many issues with MySQL 4.1's language collation feature with many softwares. If you want to run a multilanguage site, I suggest that you use utf8 as your base character set in MySQL 4.1

After all, utf8 is the most flexible charset around. 

CHARSET: utf8
COLLATE: utf8_general_ci

Beware that utf8 and utf8_bin are different! Use the first one!

In drupal file, include/database.mysql.inc, function db_connect($url), add the following before return $connection;

mysql_query("SET NAMES 'utf8'",$connection);

Of course, all of your tables should use utf8 charset for this to work. 

This is a (BETA) HOWTO on installing s9y (0.8.1) on (virtually any) webserver + php combo without the need to configure
virtual hosts.

This work is collected from this forum and various of my own work-arounds, and has been working on my Zeus web server.
At the moment of this writing I am only tasting the first success of the work, so many things may not have been
organized well.

Following these simple steps, one should be able to get s9y ’shared installed’ on any host system that wishes to host
multiple blogs for users. This setup instruction is highly customizable and may be used by any sites.

well we just discovered yesterday that our blogs aren’t working for chinese characters! this is a big problem… and it
was due to our system setups… i spent today almost 7 hours to find out what was the problem and to fix it…

finally, just insert the following 2 lines in include/db/mysql.inc.php

mysql_query(’SET NAMES gb2312;’, $serendipity[’dbConn’]);
mysql_query(’SET collation_connection = \’gb2312_chinese_ci\’;', $serendipity[’dbConn’]);

to add support to MySQL 4.1 database with language not set to UTF-8, one must add the following to the wp-includes/wp-db.php file, in function wpdb, at the end:

@mysql_query(’SET NAMES gb2312;’, $this->dbh);
@mysql_query(’SET collation_connection = \’gb2312_chinese_ci\’;', $this->dbh);

Replace “gb2312″ and “gb2312_chinese_ci” to your appropriate settings.