Drupal MySQL 4.1 tweaks for multilanguage

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.