BiTel

Table;Create Table

rentsoft_payment_25;CREATE TABLE `rentsoft_payment_25` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `txid` varchar(64) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cid` int(11) NOT NULL,
  `comment` varchar(255) NOT NULL,
  `amount` int(11) NOT NULL,
  `status` tinyint(5) NOT NULL,
  `product_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `txid` (`txid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8

show variables like 'character_set_database'
character_set_database;utf8

SHOW CREATE database bgbilling
bgbilling;CREATE DATABASE `bgbilling` /*!40100 DEFAULT CHARACTER SET utf8 */

SHOW CREATE TABLE rentsoft_product_25
rentsoft_product_25;CREATE TABLE `rentsoft_product_25` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `serviceKey` varchar(64) NOT NULL,
  `serviceName` varchar(64) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `serviceKey` (`serviceName`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=cp1251

rentsoft_payment_25;CREATE TABLE `rentsoft_payment_25` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `txid` varchar(64) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cid` int(11) NOT NULL,
  `comment` varchar(255) NOT NULL,
  `amount` int(11) NOT NULL,
  `status` tinyint(5) NOT NULL,
  `product_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `txid` (`txid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8

# locale
LANG=ru_RU.utf8
LC_CTYPE="ru_RU.utf8"
LC_NUMERIC="ru_RU.utf8"
LC_TIME="ru_RU.utf8"
LC_COLLATE="ru_RU.utf8"
LC_MONETARY="ru_RU.utf8"
LC_MESSAGES="ru_RU.utf8"
LC_PAPER="ru_RU.utf8"
LC_NAME="ru_RU.utf8"
LC_ADDRESS="ru_RU.utf8"
LC_TELEPHONE="ru_RU.utf8"
LC_MEASUREMENT="ru_RU.utf8"
LC_IDENTIFICATION="ru_RU.utf8"
LC_ALL=

db.url=jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=cp1251

echo "SET FOREIGN_KEY_CHECKS=0;" > /root/unicode.sql
mysql -uroot -pxxxxxxxx -e "SHOW TABLES IN bgbilling;" | tail -n +2 | xargs -I '{}' echo -e  "ALTER TABLE {} CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;\nSHOW WARNINGS;" >> /root/unicode.sql
echo "SET FOREIGN_KEY_CHECKS=1;" >> /root/unicode.sql
mysql -uroot -pxxxxxx -vvv bgbilling < /root/unicode.sql 2>&1 >> /root/unicode.log
mysql -uroot -pxxxxxx -e "alter  database bgbilling DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE = utf8_unicode_ci;"

UPDATE bill_data_5 SET xml = REPLACE(xml, 'windows-1251', 'utf-8');
ALTER table bill_data_5 CHANGE xml xml mediumtext CHARACTER SET cp1251;
ALTER TABLE bill_data_5 MODIFY xml mediumtext CHARACTER SET utf8;
ALTER table bill_data_5 CHANGE xml xml mediumblob;