mysql> show full columns from customer_scene
;
+--------------+-------------+-------------------+------+-----+---------+----------------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+--------------+-------------+-------------------+------+-----+---------+----------------+---------------------------------+---------+
| id | int(11) | NULL | NO | PRI | NULL | auto_increment | select,insert,update,references | |
| scene_name | varchar(30) | latin1_swedish_ci | NO | | NULL | | select,insert,update,references | |
| createTime | datetime(6) | NULL | NO | | NULL | | select,insert,update,references | |
| userspace_id | int(11) | NULL | NO | MUL | NULL | | select,insert,update,references | |
| timer | datetime(6) | NULL | YES | | NULL | | select,insert,update,references | |
+--------------+-------------+-------------------+------+-----+---------+----------------+---------------------------------+---------+
5 rows in set
mysql> alter table customer_scene modify scene_name varchar(30) character set utf8;
Query OK, 0 rows affected
Records: 0 Duplicates: 0 Warnings: 0
mysql> show full columns from customer_scene;
+--------------+-------------+-----------------+------+-----+---------+----------------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+--------------+-------------+-----------------+------+-----+---------+----------------+---------------------------------+---------+
| id | int(11) | NULL | NO | PRI | NULL | auto_increment | select,insert,update,references | |
| scene_name | varchar(30) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
| createTime | datetime(6) | NULL | NO | | NULL | | select,insert,update,references | |
| userspace_id | int(11) | NULL | NO | MUL | NULL | | select,insert,update,references | |
| timer | datetime(6) | NULL | YES | | NULL | | select,insert,update,references | |
+--------------+-------------+-----------------+------+-----+---------+----------------+---------------------------------+---------+
5 rows in set
mysql>
Mysql Err:1366, u"Incorrect string value
最新推荐文章于 2023-08-12 12:10:40 发布