The **compare-on-binary way** is **NOT semantically-correct**GROUP BY BINARY CASE WHEN BINARY `城市` = BINARY '北京 ' THEN '北京111' ELSE `城市` ENDCREATE TABLE `中文测试表1` (
`城市` varchar(50)
['ssentence']:在上面的代码中,我试图通过api进行情感分析并将它们存储到list.However中,api只输入GBK格式,而我的数据是以utf-8编码的。因此,它通常会遇到这样的错误:
UnicodeEncodeError: 'gbk' codec can't encode character '\u30fb' in position 14: illegal