问题现象
insert select nvl(varchar,varbinary)语句执行报错 failed to query in gnode:
DETAIL: Incorrect string value: '\xEF\xBC' for column 'c' at row 1
解决方法:
varbinary 字段修改成 varchar,或者加 to_char 函数
11-24
5428
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
03-28
3165
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
04-01
5073
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)