Make tables compatible with UTF8

Drupal has recently changed all table definitions for compatibility with unicode. I believe contrib modules should also

MySQL tables:

CREATE TABLE browscap (
  ...
  ...
  ...
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

CREATE TABLE browscap_statistics (
  ...
  ...
  ...
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

To update existing installations, add the following somewhere in the module script:

/**
 * Update database hooks
 */
function browscap_update_1() {
  return _system_update_utf8(array('browscap', 'browscap_statistics'));
}

and run the Drupal update.php script.

Cheers