MySql超長(zhǎng)自動(dòng)截?cái)鄬?shí)例詳解
小伙伴問到一個(gè)問題，為啥在項(xiàng)目中調(diào)用插入或者更新語(yǔ)句時(shí)超長(zhǎng)的字無(wú)法自動(dòng)截?cái)啵趎avicat中直接執(zhí)行是可以自動(dòng)截?cái)嗟模?/p>
如下
| CREATE TABLE `p_app_station` ( `WX_APP_ID` varchar(20) NOT NULL, `APP_SECRET` varchar(33) DEFAULT NULL, `IS_BINDING` int(1) DEFAULT '0', `ACCOUNT_ID` int(13) DEFAULT NULL, `TOKEN` varchar(40) DEFAULT NULL, `BIND_URL` varchar(200) DEFAULT NULL, `WX_APP_NAME` varchar(50) DEFAULT NULL, `WX_APP_SID` varchar(50) DEFAULT NULL, `WX_NO` varchar(50) DEFAULT NULL, `CREATE_USER_ID` varchar(13) DEFAULT NULL, `UPDATE_DATE` datetime DEFAULT NULL, `CREATE_DATE` datetime DEFAULT NULL, `UPDATE_USER_ID` varchar(13) DEFAULT NULL, `STATION_TYPE` int(1) unsigned zerofill DEFAULT NULL COMMENT '標(biāo)記類型（試用版:0,會(huì)員版:1,定制版:2）', `ACTIVE_DATE` datetime DEFAULT NULL COMMENT '使用時(shí)間截止', `APP_MODULE_ID` varchar(60) DEFAULT NULL COMMENT '推送模版消息ID', PRIMARY KEY (`WX_APP_ID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
| insert into p_app_station(wx_app_id) values('12121312312312啊啊啊啊啊aassasdasd');select * from p_app_station where wx_app_id like '12121312312312%'; |
很明顯varchar(20) 不足以容納12121312312312啊啊啊啊啊aassasdasd
查詢結(jié)果如下
確實(shí)自動(dòng)截?cái)嗔?，但是在?xiàng)目中執(zhí)行同樣的sql發(fā)現(xiàn)并非如此，反而報(bào)錯(cuò)。
| Data truncated for column '%s' at row %ld |
考慮到是同一個(gè)數(shù)據(jù)庫(kù)，不存在模式不同，那么可能性應(yīng)該出現(xiàn)在jdbcDriver上。
查看jdbc源碼
| private void setupServerForTruncationChecks() throws SQLException { if (getJdbcCompliantTruncation()) { if (versionMeetsMinimum(5, 0, 2)) { String currentSqlMode = this.serverVariables.get("sql_mode"); boolean strictTransTablesIsSet = StringUtils.indexOfIgnoreCase(currentSqlMode, "STRICT_TRANS_TABLES") != -1; if (currentSqlMode == null || currentSqlMode.length() == 0 || !strictTransTablesIsSet) { StringBuilder commandBuf = new StringBuilder("SET sql_mode='"); if (currentSqlMode != null && currentSqlMode.length() > 0) { commandBuf.append(currentSqlMode); commandBuf.append(","); } commandBuf.append("STRICT_TRANS_TABLES'"); execSQL(null, commandBuf.toString(), -1, null, DEFAULT_RESULT_SET_TYPE, DEFAULT_RESULT_SET_CONCURRENCY, false, this.database, null, false); setJdbcCompliantTruncation(false); // server's handling this for us now } else if (strictTransTablesIsSet) { // We didn't set it, but someone did, so we piggy back on it setJdbcCompliantTruncation(false); // server's handling this for us now } } }} |
新聞熱點(diǎn)
疑難解答
圖片精選
