Not supporting MySQL 5.5.2 and older

[zhangbenber]

This library does not support MySQL 5.5.2 and older since it creates tables using utf8mb4, which is not supported by older versions of MySQL.

I created the table by myself using utf8_bin, and it seems working for me. However, this conflicts with Issue #49, will you add MySQL version detecting before creating the table, or at least, add a Compatibility section in README, and provide a collation option for some workarounds?

[chill117]

Looks like the utf8mb4 collation was added in MySQL 5.5.3 in early 2010. That's a long way back. Can you not upgrade your MySQL version?

[zhangbenber]

@chill117, I agree with you and I am considering updating my MySQL. But I didn't see any warnings or tips about what happened, and it confused me.

I suggest a tip in README may help it better. Thank you all the same.

[chill117]

@zhangbenber Yes, it would be nice to somehow save the next person some time either with a note in the readme about the collation or better yet a check (and warning) in the module itself if the old version (or a lack of proper collation support) is detected. It should be possible to look-up the collations which the database supports.

[chill117]

Added a note to the readme.