<?php
// $Id$

/**
 * @file
 * Installation functions for Custom module.
 */

/**
 * Convert database/table/column collations from utf8_general_ci to utf8_unicode_ci.
 *
 * @see http://drupal.org/node/772678
 */
function custom_update_6000() {
  global $db_url;
  $ret = array();

  // Retrieve database name from global $db_url.
  // @see db_set_active()
  if (is_array($db_url)) {
    $url = $db_url['default'];
  }
  else {
    $url = $db_url;
  }
  // @see db_connect()
  $url = parse_url($url);
  $database = substr(urldecode($url['path']), 1);

  // Convert/ensure default database collation.
  $ret[] = update_sql("ALTER DATABASE $database DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci");

  // Convert tables and columns.
  $schema = drupal_get_schema();
  foreach ($schema as $table => $info) {
    $ret[] = update_sql("ALTER TABLE {" . $table . "} CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci");
  }

  return $ret;
}