Re: characters converted to ??? in postgres

On 1/11/18 16:34, armand pirvu wrote:
> On OS X:
> - case 1 fails
> testdb=# insert into jt1 values ('??') ;
> ERROR:  invalid byte sequence for encoding "UTF8": 0xe2 0xa4 0x27
> Note that at paste time  ≤ changed in ??

This looks like something is wrong with your libedit library.  Try
running psql with the -n option.  If that helps, then look into building
psql with libreadline instead.  Because libedit is terrible.

> - case 2 is fine
> - echo -n '≤' |hexdump -C
> 00000000  e2 89 a4                                          |...|
> 00000003

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services