Re: characters converted to ??? in postgres - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: characters converted to ??? in postgres
Date
Msg-id 49e0edb1-5de6-21b2-6ab4-5264aff6b661@2ndquadrant.com
Whole thread Raw
In response to characters converted to ??? in postgres  (armand pirvu <armand.pirvu@gmail.com>)
Responses Re: characters converted to ??? in postgres  (armand pirvu <armand.pirvu@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: armand pirvu
Date:
Subject: characters converted to ??? in postgres
Next
From: Michael Paquier
Date:
Subject: Re: Missing WAL file after running pg_rewind