解决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;

posted @ 2017-11-28 20:14  wq920  阅读(1584)  评论(0编辑  收藏  举报