mysql> set names 'gbk'; Query OK, 0 rows affectedmysql> select length('sdf是否sf'); +---------------------+ | length('sdf是否sf') | +---------------------+ | 9 | +---------------------+ 1 row in setmysql> select char_length('sdf是否sf'); +--------------------------+ | char_length('sdf是否sf') | +--------------------------+ | 7 | +--------------------------+ 1 row in set
并且客户端提示消息 必须含有中文TRIGGER中无法实现这种功能。
DELIMITER $$ 假设ID唯一,且已经有=1的记录,姓名为你要插入的字段 CREATE TRIGGER `AA1` BEFORE INSERT ON `AA1` FOR EACH ROW BEGIN IF NEW.姓名 REGEXP '[^ -~]'<>1 THEN SET NEW.ID=1; END IF; END$$DELIMITER ;
Query OK, 0 rows affectedmysql> select length('sdf是否sf');
+---------------------+
| length('sdf是否sf') |
+---------------------+
| 9 |
+---------------------+
1 row in setmysql> select char_length('sdf是否sf');
+--------------------------+
| char_length('sdf是否sf') |
+--------------------------+
| 7 |
+--------------------------+
1 row in set
假设ID唯一,且已经有=1的记录,姓名为你要插入的字段
CREATE TRIGGER `AA1` BEFORE INSERT ON `AA1`
FOR EACH ROW BEGIN
IF NEW.姓名 REGEXP '[^ -~]'<>1 THEN
SET NEW.ID=1;
END IF; END$$DELIMITER ;