"Hu, Patricia" <Patricia.Hu@xxxxxxxxx> writes: > The server and client encoding are both set to UTF8, and according to this http://www.fileformat.info/info/unicode/char/2013/index.htm en dash is a valid UTF8 character, but when running a script with insert statement with en dash character in it, I got the error below. > psql:activity_type.lst:379: ERROR: invalid byte sequence for encoding "UTF8": 0x96 Well, that certainly isn't valid UTF8, so your script file isn't in UTF8. > If I set client_encoding to WIN1252, the same file will be run ok 0x96 does seem to be an en-dash in WIN1252, so this is probably the appropriate fix. Testing here says that PG will correctly convert 0x96 in WIN1252 to an en-dash (U+2013) in UTF8, so I think you are getting the right thing inserted. > but afterwards the en dash character showed up as "û", instead of the en dash character "-" This indicates that your terminal program does *not* think its encoding is WIN1252. Having loaded that script file, you need to revert client_encoding to whatever your terminal program is using, or non-ASCII characters are going to be displayed wrong. A bit of poking around suggests that your terminal may be operating with code page 437 or similar, as 0x96 is "û" in that encoding --- according to Wikipedia, at least: https://en.wikipedia.org/wiki/Code_page_437 I don't think Postgres supports that as a client_encoding setting, so one way or another you're going to need to switch the terminal program's character set setting. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
