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 […]
Read More →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;
Read More →The steps would be copy the record to temp table modify the column you would like to copy back to the original table CREATE TEMPORARY TABLE tmp SELECT * FROM table_1 WHERE column_1 = 111; UPDATE tmp SET column_1 =1 WHERE column_1 = 111; INSERT INTO table_1 SELECT * FROM tmp WHERE column_1 = 1;
Read More →