Create a Chinese name for the Worker packet error（创建中文名称的Worker分组报错） #183
Description
The group name is Chinese name and the save will fail.
SQL: SELECT * FROM t_escheduler_worker_group WHERE (name = ?)
### Cause: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci, IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
After analysis, it is judged whether the name has an error.
at cn.escheduler.api.service.WorkerGroupService.checkWorkerGroupNameExists(WorkerGroupService.java:91) ~[classes/:na]
View the table structure.
`name` varchar(256) CHARACTER SET latin1 DEFAULT NULL COMMENT 'group name',
`ip_list` varchar(256) CHARACTER SET latin1 DEFAULT NULL COMMENT 'worker address list',
The reason is that the characters do not match, change the structure below to ok
组名称为中文名称，保存会失败
SQL: SELECT * FROM t_escheduler_worker_group WHERE (name = ?)
### Cause: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
经过分析是在判断名称是否存在报错
at cn.escheduler.api.service.WorkerGroupService.checkWorkerGroupNameExists(WorkerGroupService.java:91) ~[classes/:na]
查看了表结构。
`name` varchar(256) CHARACTER SET latin1 DEFAULT NULL COMMENT '组名称',
`ip_list` varchar(256) CHARACTER SET latin1 DEFAULT NULL COMMENT 'worker地址列表',
原因就是字符不匹配，改下表结构就ok