Z-Car

Ramblings about everything from Cars to Computers

MySQL Collate and Case Sensitivity – Flexible Compare

By Prodromus August 31, 2010 MySQL No Comments

In a typical MySQL installation, the default character set and collation are latin1 and latin1_swedish_ci. This means that all string comparisons will be performed in a case insensitive manner. So, ‘Search String’=’search string’. This…

MySQL – ERROR 1005: Can’t create table (errno: 150) – INNODB

By Prodromus May 13, 2010 Errors, MySQL No Comments

If you have seen this error, don’t worry, you are not alone. This error is often accompanied by a message that a table or file could not be created, and…