A 'runtime' requirements checker (admin/reports/status) for checking all database tables have the right database collation (probably very MySQL centric).

Offers the ability to fix tables with wrong database collation.

The collation is either specified in your database settings or in hook_schema() or hook_schema_alter().

This can be useful when developing non-english sites.

Example of specifying in database settings in settings.php (will affect all tables - it's probably better to do it in hook_schema() or hook_schema_alter()):

$databases = array(
  'default' => array(
    'default' => array(
      'database' => 'my-db',
      'username' => 'my-user',
      'password' => 'my-password',
      'host' => 'localhost',
      'port' => '',
      'driver' => 'mysql',
      'prefix' => '',
      'charset' => 'utf8mb4',
      'collation' => 'utf8mb4_danish_ci',
    ),
  ),
);

See also Multi-byte UTF-8 support in Drupal 7 and UTF8MB4 Convert.

Example of specifying via hook_schema_alter():

/**
 * Implements hook_schema_alter().
 */
function my_module_schema_alter(&$schema) {
  $schema['field_data_title_field']['collation'] = 'utf8mb4_danish_ci';
}

If you (as a developer) changes the collation of an existing table you will probably want to fix the table right away in a hook_update_N():

/**
 * Fix collation of {my_table}.
 */
function my_module_update_7101(&$sandbox) {
  collation_fixer_fix_collation('my_table');
}

Collation Fixer

Issues

Access denied for table metadata and other issuesClosed: outdatedCode Created about 5 years ago

Access denied for table metadata and other issues
Closed: outdated
Code
Created about 5 years ago