As for the which version of MySQL to support dilema, right now it doesn't take much to get the emulator to use MySQL 4.1 or MySQL 5.0. For MySQL 5.0, the only real code change needed was to change the queries that referenced that "condition" column to "_condition" instead. Other than that, it was just a matter of not setting text or blob types to any Default values in the database script and then all you have to do is to compile while referencing the correct MySQL libs.
I agree for now the official builds should go on to support MySQL 4.0.26. But as coding goes forth, I know I'll continue to use MySQL 5.0 now so if/when I see any other code that is too 4.0.26 specific to function on 4.1 or 5.0, I'll not it and I hope you or doodman will use that code so the codebase itself can be used for any MySQL version as long as the server operator does the compiling themselves.
|