ERROR: invalid byte sequence for encoding "UTF8": 0x80
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
错误: 无效的 "UTF8" 编码字节顺序: 0xb7
HINT: 如果字节顺序与服务器期待的编码(由"client_encoding"控制)不匹配,那么这个错误也会发生
-----------------------------------------------------------------------
PostgreSQL创建的数据库默认的编码是utf-8
set client_encoding=gbk
show client_encoding”来查看当前的客户编码,同时也可以使用”\encoding CLIENT-ENCODING”来设置客户端编码。
:client_encoding和server_encoding 是2个不同的概念
阅读(4972) | 评论(0) | 转发(0) |