stark, это ж InetAccess там нет data.properties 
Код:
<!-- Параметры подключения к БД -->
<param name="db.driver" value="com.mysql.jdbc.Driver"/>
<param name="db.url" value="jdbc:mysql://10.0.6.5/bgbilling?useUnicode=true&characterEncoding=UTF-8&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&queryTimeoutKillsConnection=true&connectTimeout=1000"/>
Код:
inet_auth_error_12_201510 | CREATE TABLE `inet_auth_error_12_201510` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`deviceId` int(11) NOT NULL,
`deviceTitle` char(15) NOT NULL,
`contractId` int(11) NOT NULL,
`contractTitle` char(15) NOT NULL,
`servId` int(11) NOT NULL,
`hash` int(11) NOT NULL DEFAULT '0',
`servTitle` char(100) NOT NULL,
`code` int(11) NOT NULL,
`count` int(11) NOT NULL DEFAULT '1',
`lastTime` datetime NOT NULL,
`logCoordinateRecordId` int(11) NOT NULL,
KEY `id` (`id`),
KEY `deviceId` (`deviceId`),
KEY `lastTime` (`lastTime`),
KEY `time_dcsc` (`lastTime`,`deviceId`,`contractId`,`servId`,`code`,`hash`)
) ENGINE=InnoDB AUTO_INCREMENT=686166 DEFAULT CHARSET=cp1251
/*!50100 PARTITION BY RANGE (TO_DAYS(lastTime))
(PARTITION p20151001 VALUES LESS THAN (736242) ENGINE = InnoDB,
PARTITION p20151006 VALUES LESS THAN (736247) ENGINE = InnoDB,
PARTITION p20151011 VALUES LESS THAN (736252) ENGINE = InnoDB,
PARTITION p20151016 VALUES LESS THAN (736257) ENGINE = InnoDB,
PARTITION p20151021 VALUES LESS THAN (736262) ENGINE = InnoDB,
PARTITION p20151026 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */ |
Код:
mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | cp1251 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | cp1251 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
Код:
mysql> SHOW VARIABLES LIKE 'colla%';
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | utf8_general_ci |
| collation_database | cp1251_general_ci |
| collation_server | cp1251_general_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)
collation_database и collation_server тянутся еще с 5.1(2), скорее всего.
Я так понимаю, что рекомендацией будет перевести в my.cnf все в UTF-8, поменять db.url в настройках всех приложений (в BGBillingServer/data/data.properties у меня стоит cp1251 в db.url ).
Вход
Регистрация
FAQ
Поиск
