Workaround to run Umbraco V4 on MySQL V4

I had some troubles running Umbraco version 4 on a MySQL database version 4. I developed a website on a MySQL V5 database, which works fine. The problem occured when I tried to place a backup on the live environment which appeared to be MySQL version 4.

The following error message was shown:
ERROR 1074 (42000) at line 1947: Column length too big for column 'EMAIL' (max = 255); use BLOB or TEXT instead

It seems that you cannot use varchar(1000) on MySQL 4. In the backup script (which is an sql file) I replaced all varchar(1000) into TinyText (thanks to my colleague Arno Raps) and as far as I can see now, it works fine.

Unfortunately, this problem is not well documented on Umbraco, so I just post it here...

Umbraco - Free CMS

I just found on the internet Umbraco. This is a free CMS system and it looks great. The current release is version 3.0.6. I saw a screenshot of it, and that looks really great!
Check it out at: http://www.codeplex.com/umbraco

Unfortunately, the back-end database is a SQL Server variant. To use it with MySQL or a database you like, you should wait untill release 4, which will be the next release. They expect a final release of version 4 at the end of this year. That's why I have to wait until then.
For the time being, I just play around with version 3.0.6 on a virtual pc (currently trying to install the whole stuff).

I am really looking forward to use this product. To get an indication of the quality, peugeot company, Heinz and even Microsoft (MS Developer Network in Denmark) are using this platform.