Windows

Open docx and xlsx files in older versions of word and excel

Submitted by charles on
I've received a couple of files in the new microsoft office 2007 file formats, and as I have as yet not upgraded, was not able to open them. There is now a compatability pack that's been released that will allow you to open new files in older versions of office: download it here. Read the overview and system requirements first!

MySQL case sensitivity of table names between windows and linux systems

Submitted by charles on
While I normally stick to all lowercase table names for my MySQL database tables, I often have to come in on a project where the database has already been set up using a mixture of lower and uppercase table names. Because windows is case-insensitive, when you create a MySQL table or export tables for use on a linux system, all table names will be lowercase by default. This will cause problems when the dump imported into MySQL on linux, as any calls to the original mixed case tables will result in errors, as these tables don't actually exist.