note to self – collation is important when installing umbraco

I was having problems getting the latest build of Umbraco to install on localhost and kept getting errors like:

Invalid column name ‘defaultToLiveEditing’.

After much googling and searching around the umbraco forums i discoverd that the collation on the database needs to be set to case insensitive otherwise the sql script freaks out and doesn’t install all the columns in to the users table.