sunpeng <bluevaley@xxxxxxxxx> wrote: > load data to postgresql in cmd(encoding is GBK) is WIN8: > psql -h localhost -d test -U postgres < dbdata.sql > > I got the error: > ERROR: invalid byte sequence for encoding "UTF8": 0xff If the encoding is GBK then you will get errors (or incorrect characters) if it is read as UTF8. Try setting the environment variable PGCLIENTENCODING. http://www.postgresql.org/docs/9.1/static/app-psql.html -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
