Mysql auto_increment for binary?
===

I'm currently using [binary(16)][1] to represent a 128-bit unique integer field in a MySQL database.

Afaik, [auto_increment][2] is only available for integer types.

What is the best way to make a binary field auto increment?


  [1]: http://dev.mysql.com/doc/refman/5.0/en/binary-varbinary.html
  [2]: http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html