Converting MySQL tables to UTF-8
Quick and easy code to convert the character set of a MySQL table to UTF-8. Of course this works for all character sets not just UTF ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Home »
MySQL
Speeding up MySQL
I recently rebuilt the Cornwall24 website in the hope that upgrading from a 3 year old verwion of PostNuke to a new version of WordPress might stop the site taking down the server by overloading MySQL at least once a… Read More »Speeding up MySQL
Caching remote MySQL queries with PHP
The problem: What I wanted to do here was find a way of speeding up a query that was run on MySQL database on a different server. Also I’m a big fan of caching generally, especially when the data is… Read More »Caching remote MySQL queries with PHP