Re: [GENERAL] loading file with en dash character into postgres 9.6.1 database

2017-07-12 Thread Hu, Patricia
-general@postgresql.org) Subject: [EXTERNAL] RE: [GENERAL] loading file with en dash character into postgres 9.6.1 database Tom Lane wrote: > "Hu, Patricia" <patricia...@finra.org> writes: >> The server and client encoding are both set to UTF8, and according to >>

Re: [GENERAL] loading file with en dash character into postgres 9.6.1 database

2017-07-12 Thread Albe Laurenz
Tom Lane wrote: > "Hu, Patricia" 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

Re: [GENERAL] loading file with en dash character into postgres 9.6.1 database

2017-07-11 Thread Tom Lane
"Hu, Patricia" 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

[GENERAL] loading file with en dash character into postgres 9.6.1 database

2017-07-11 Thread Hu, Patricia
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. mydb=> select name,