在database1
:
-
show LC_CTYPE;
显示C
-
show LC_COLLATE;
显示C
-
show SERVER_ENCODING;
显示UTF8
但是set "PGPASSWORD=password1" & set "PGCLIENTENCODING=UTF8" & psql.exe -h 127.0.0.1 -p 5432 -U postgres -d database1 -c "INSERT INTO table1 (column1) VALUES ('mise à jour 1');"
显示:ERROR: invalid byte sequence for encoding "UTF8": 0xc8 0x20
例如,如果将PGCLIENTENCODING
设置为ISO_8859_5
,则错误消失
如何解决此问题?