解决hue查询中文报错问题

时间:2023-03-09 09:29:49
解决hue查询中文报错问题

hue 4.0查询查询中包含中文报一下错误

(1366, Incorrect string value: \\xE4\\xBA\\xAC\\xE4\\xB8\\x9C... for column search at row 1)

解决方案如下:

ALTER TABLE desktop_document2 modify column name varchar(255) CHARACTER SET utf8;

ALTER TABLE desktop_document2 modify column description longtext CHARACTER SET utf8;

ALTER TABLE desktop_document2 modify column search longtext CHARACTER SET utf8;