错误信息:
peimsmdb=# select '我';
ERROR: character with byte sequence 0xe6 0x88 0x91 in encoding "UTF8" has no equivalent in encoding "LATIN1"
查看客户端字符集:
peimsmdb=# show client_encoding;
client_encoding
-----------------
UTF8
peimsmdb=# show server_encoding;
server_encoding
-----------------
LATIN1
思路:
因为没有修改环境变量,导致安装完数据库,数据库默认字符集变成LAT