Search Postgresql Archives

Re: characters converted to ??? in postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux