One important feature of new Zen Cart 1.3.x is out of the box support of MySQL 5.x However, for some reason, it is not explicitly mentioned in release notes.
If you choose to have Zen Cart 1.2. with MySQL 5., you sentence yourself to fixing many pieces of badly written SQL queries as described in this forum thread.