Как вариант:
dmsuslov писал(а): Варианты решения:
1) Сложный. Переконвертировать содержимое базы данных в кодировку, указанную в переменной $lang['ENCODING'].
Воспользоваться перловым скриптом, надыбал его в инете для таких же нужд но конвертил из latin1.
Данный скрипт создаёт файлик с SQL запросами типа ALTER TABLE и ALTER DATABASES для смены кодировки всех полей, всех найденных таблиц, который потом заливаем на сервер.
Вот, отредактировал его для ваших целей. Код сохраняем в файлик и выполняем с помощью утилиты perl (ЗЫ: испытано в linux`e, с виндой не шипко дружу).
Код: Выделить всё
#!/usr/bin/perl
use warnings;
use strict;
use DBI;
unless( 4 == @ARGV ) {
print STDERR "Usage: $0 <host> <database> <user> <password>\n";
exit 1;
}
my ($host, $database, $user, $password) = @ARGV;
die "bad host/db/user" unless $host =~ /^[\w\-\.]+$/ and $database =~ /^[\w_]+$/ and $user =~ /^[\w_]+$/;
my $dbh = DBI->connect("DBI:mysql:database=$database;host=$host", $user, $password, {'RaiseError' => 1});
my (@pass0, @pass1, @pass2, @pass3) = ();
my $sth = $dbh->prepare("SHOW CREATE DATABASE $database");
$sth->execute;
my @arr = $sth->fetchrow_array;
$arr[1] =~ /^CREATE DATABASE `$database` \/\*!\d+ DEFAULT CHARACTER SET cp1251( COLLATE cp1251_\w+)? \*\/$/
or die "bad database spec: $arr[1]";
push @pass1, "ALTER DATABASE `$database` DEFAULT CHARACTER SET cp1251";
push @pass2, "ALTER DATABASE `$database` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci";
$sth = $dbh->prepare("SHOW TABLES");
$sth->execute;
my @tables = ();
while( my @row = $sth->fetchrow_array ) {
die "bad table name: $row[0]" unless $row[0] =~ /^[\w_]+$/;
push @tables, $row[0];
}
foreach my $table (@tables) {
$sth = $dbh->prepare("SHOW CREATE TABLE `$table`");
$sth->execute;
my @row = $sth->fetchrow_array;
$row[1] =~ s/ COMMENT='[^'\\]*'$//s;
$row[1] =~ /^CREATE TABLE `$table` \(.*\)([^)]+)$/s
or die "bad table spec: $row[1]";
my $tail = $1;
unless( $tail =~ /\bDEFAULT CHARSET=cp1251\b/ ) {
die "bad table $table spec tail: $tail";
}
push @pass1, "ALTER TABLE `$table` DEFAULT CHARSET cp1251";
push @pass2, "ALTER TABLE `$table` DEFAULT CHARSET utf8 COLLATE utf8_general_ci";
my (%fulltext, %column_in_fulltext_indexes, %remove_fulltext_indexes) = ();
$sth = $dbh->prepare("SHOW INDEX FROM `$table`");
$sth->execute;
while( my $row = $sth->fetchrow_hashref ) {
next unless $row->{Index_type} eq "FULLTEXT";
$fulltext{$row->{Key_name}} ||= [];
$fulltext{$row->{Key_name}}[$row->{Seq_in_index}-1] = $row->{Column_name};
$column_in_fulltext_indexes{$row->{Column_name}} ||= [];
push @{$column_in_fulltext_indexes{$row->{Column_name}}}, $row->{Key_name};
}
$sth = $dbh->prepare("SHOW FULL COLUMNS FROM `$table`");
$sth->execute;
while( my @row = $sth->fetchrow_array ) {
my ($column, $type, $collation) = @row[0,1,2];
if( defined $collation and "NULL" ne $collation ) {
die "bad collation in column $column of table $table: $collation" unless $collation =~ /^cp1251_\w+$/;
push @pass1, "ALTER TABLE `$table` MODIFY COLUMN `$column` $type CHARACTER SET cp1251";
push @pass2, "ALTER TABLE `$table` MODIFY COLUMN `$column` $type CHARACTER SET utf8 COLLATE utf8_general_ci";
foreach my $index (@{$column_in_fulltext_indexes{$column}}) {
$remove_fulltext_indexes{$index} = 1;
}
}
}
foreach my $index (keys %remove_fulltext_indexes) {
push @pass0, "ALTER TABLE `$table` DROP INDEX `$index`";
push @pass3, "ALTER TABLE `$table` ADD FULLTEXT INDEX `$index` (" . join( ",", map { "`$_`" } @{$fulltext{$index}} ) . ")";
}
}
print join ";\n", "USE `$database`", @pass0, @pass1, @pass2, @pass3, "";
Ну или попробуйте воспользоваться уже готовым вариантом:
Код: Выделить всё
ALTER DATABASE `forum` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_auth_access` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_banlist` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_banlist` MODIFY COLUMN `ban_ip` char(8) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_banlist` MODIFY COLUMN `ban_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_categories` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_categories` MODIFY COLUMN `cat_title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_config` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_config` MODIFY COLUMN `config_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_config` MODIFY COLUMN `config_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_confirm` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_confirm` MODIFY COLUMN `confirm_id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_confirm` MODIFY COLUMN `session_id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_confirm` MODIFY COLUMN `code` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_disallow` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_disallow` MODIFY COLUMN `disallow_username` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_forum_prune` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_forums` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_forums` MODIFY COLUMN `forum_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_forums` MODIFY COLUMN `forum_desc` text CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_groups` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_groups` MODIFY COLUMN `group_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_groups` MODIFY COLUMN `group_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts` MODIFY COLUMN `poster_ip` char(8) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts` MODIFY COLUMN `post_username` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts_text` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts_text` MODIFY COLUMN `bbcode_uid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts_text` MODIFY COLUMN `post_subject` char(60) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts_text` MODIFY COLUMN `post_text` text CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs` MODIFY COLUMN `privmsgs_subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs` MODIFY COLUMN `privmsgs_ip` char(8) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs_text` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs_text` MODIFY COLUMN `privmsgs_bbcode_uid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs_text` MODIFY COLUMN `privmsgs_text` text CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_ranks` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_ranks` MODIFY COLUMN `rank_title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_ranks` MODIFY COLUMN `rank_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_results` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_results` MODIFY COLUMN `session_id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_results` MODIFY COLUMN `search_array` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_wordlist` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_wordlist` MODIFY COLUMN `word_text` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_wordmatch` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions` MODIFY COLUMN `session_id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions` MODIFY COLUMN `session_ip` char(8) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions_keys` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions_keys` MODIFY COLUMN `key_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions_keys` MODIFY COLUMN `last_ip` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_smilies` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_smilies` MODIFY COLUMN `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_smilies` MODIFY COLUMN `smile_url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_smilies` MODIFY COLUMN `emoticon` varchar(75) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `template_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `style_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `head_stylesheet` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_background` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_bgcolor` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_text` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_link` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_vlink` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_alink` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_hlink` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_color1` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_color2` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_color3` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_class1` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_class2` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_class3` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_color1` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_color2` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_color3` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_class1` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_class2` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_class3` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_color1` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_color2` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_color3` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_class1` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_class2` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_class3` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontface1` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontface2` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontface3` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontcolor1` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontcolor2` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontcolor3` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `span_class1` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `span_class2` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `span_class3` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_color1_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_color2_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_color3_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_class1_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_class2_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_class3_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_color1_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_color2_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_color3_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_class1_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_class2_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_class3_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_color1_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_color2_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_color3_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_class1_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_class2_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_class3_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontface1_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontface2_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontface3_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontsize1_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontsize2_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontsize3_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontcolor1_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontcolor2_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontcolor3_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `span_class2_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `span_class3_name` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_topics` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_topics` MODIFY COLUMN `topic_title` char(60) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_topics_watch` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_user_group` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `username` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_lang` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_dateformat` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_avatar` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_icq` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_website` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_from` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_sig` text CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_sig_bbcode_uid` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_aim` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_yim` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_msnm` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_occ` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_interests` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_actkey` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_newpasswd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `salt` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_desc` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_desc` MODIFY COLUMN `vote_text` text CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_results` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_results` MODIFY COLUMN `vote_option_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_voters` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_voters` MODIFY COLUMN `vote_user_ip` char(8) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_words` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_words` MODIFY COLUMN `word` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_words` MODIFY COLUMN `replacement` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
PS: Не забываем делать Резервную копию базы, перед тем как что-то в ней менять!!!!!!!!
Берусь за всё что возможно, главное, чтобы не подсунули два рубильника.