MySQL 5.6 new timestamp types need support in prep statement

[Andrew Hutchings]

MySQL 5.6 has new timestamp types. Not sure what the format is yet as it isn't documented but we need to support it.

[Wim Lewis (wiml-omni)]

The mysql 5.6 docs at <http://dev.mysql.com/doc/refman/5.6/en/c-api-data-structures.html> say:

"The MYSQL_TYPE_TIME2, MYSQL_TYPE_DATETIME2, and MYSQL_TYPE_TIMESTAMP2 type codes are used only on the server side. Clients see the MYSQL_TYPE_TIME, MYSQL_TYPE_DATETIME, and MYSQL_TYPE_TIMESTAMP codes."

and a glance through the sources at lp:mysql-server doesn't show any protocol packing/unpacking code for those types, just for the usual ones.

[Andrew Hutchings (linuxjedi)]

ah ha! Thanks for looking into this, I just saw it in the types list and assumed they were actually used externally.