In order to support multi-language website, I would like to use PEAR Translation2 But only install Translation is not enough, MDB2 and MDB2#mysql also need to install pear install MDB2 pear install MDB2#mysql pear install Translation2-2.0.4 Then we would use Translation2::factory(‘MDB2’, $db_info, $params); to initialize the translation engine where $db_info consist the database information and […]

For table, we could use ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; For database, we could use ALTER DATABASE database_name charset=utf8;