sqle
sqle copied to clipboard
(未复现)规则:建议使用utf8mb4数据库字符集误触发
çæ¬ä¿¡æ¯ï¼Versionï¼
é®é¢æè¿°ï¼Describeï¼
æµè¯æ¹æ³ï¼å建ä¸ä¸ªutf8mb4 ç表ï¼ç¶å使ç¨ä¸ä¸ªä¿®æ¹å段çsqlè¯å¥å®¡æ ¸ï¼ï¼SQLè¯å¥éè¦å¨å é¨å£°æå符éï¼
CREATE TABLE user_message (
id INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主é®ID',
content VARCHAR(500) NOT NULL COMMENT 'æ¶æ¯å
容',
sender VARCHAR(20) DEFAULT NULL COMMENT 'åé人ï¼å¾
ä¿®æ¹ï¼',
send_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'åéæ¶é´',
is_read TINYINT NOT NULL DEFAULT 0 COMMENT 'æ¯å¦å·²è¯»ï¼0ï¼æªè¯»ï¼1ï¼å·²è¯»ï¼',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='ç¨æ·æ¶æ¯è¡¨';
-- å®¡æ ¸è¯¥è¯å¥
ALTER TABLE user_message
MODIFY COLUMN sender
varchar(50)
CHARACTER SET utf8mb4
COLLATE utf8mb4_general_ci
DEFAULT ''
NOT NULL
COMMENT 'åé人';
æªå¾ææ¥å¿ï¼Logï¼
å¦ä½å¤ç°ï¼To Reproduceï¼
é®é¢åå
è§£å³æ¹æ¡
åæ´å½±åé¢
åå½±åçæ¨¡åæåè½
å¤é¨å¼ç¨çæ½å¨é®é¢æé£é©
çæ¬å ¼å®¹æ§
æµè¯å»ºè®®
未能复现
开启所有规则,在V1和V2上都未能复现