lightdb for postgresql ERROR: invalid byte sequence for encoding "UTF8": 0xc92c解决方法

ltsql执行sql文件时报ERROR:  invalid byte sequence for encoding "UTF8": 0xc92c。原因是文件的编码和当前用户环境的编码不一致。

通过010 Editor可以查看编码格式，file命令不一定可以。

 这确实是编码的问题，可以通过修改环境变量或client_encodinghttps://www.feiqueyun.cn/zixun/jishu/193249.html解决。

 https://stackoverflow.com/questions/4867272/invalid-byte-sequence-for-encoding-utf8

但是下面的情况比较复杂，必须确保客户端和服务端编码完全一致：

zjh@zjhdb=# show %encoding%;
name | setting | description
-----------------+---------+----------------------------------------------------
client_encoding | UTF8 | Sets the client's character set encoding.
server_encoding | UTF8 | Sets the server (database) character set encoding.
(2 rows)

zjh@zjhdb=# create table t(t text);
CREATE TABLE
zjh@zjhdb=# insert into t values('中国');
INSERT 0 1
zjh@zjhdb=# exit
[zjh@hs-10-20-30-193 ~]$ echo $LANG
en_US.UTF-8
[zjh@hs-10-20-30-193 ~]$ export LANG=zh_CN.GBK
[zjh@hs-10-20-30-193 ~]$ echo $LANG
zh_CN.GBK
[zjh@hs-10-20-30-193 ~]$ ltsql -p25432 zjhdb
ltsql (13.8-22.3)
Type "help" for help.

zjh@zjhdb=# insert into t values('中国');
ERROR:  character with byte sequence 0xad 0xe5 in encoding "GBK" has no equivalent in encoding "UTF8"
zjh@zjhdb=# show %encoding%;
      name       | setting |                    description                     
-----------------+---------+----------------------------------------------------
 client_encoding | GBK     | Sets the client's character set encoding.
 server_encoding | UTF8    | Sets the server (database) character set encoding.
(2 rows)

zjh@zjhdb=# exit
[zjh@hs-10-20-30-193 ~]$ export LANG=zh_CN.GB2312
[zjh@hs-10-20-30-193 ~]$ ltsql -p25432 zjhdb
ltsql (13.8-22.3)
Type "help" for help.

zjh@zjhdb=# insert into t values('中国');
ERROR:  character with byte sequence 0xad 0xe5 in encoding "EUC_CN" has no equivalent in encoding "UTF8"