Re: characters converted to ??? in postgres

From: armand pirvu <armand(dot)pirvu(at)gmail(dot)com>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: characters converted to ??? in postgres
Date: 2018-01-13 03:11:36
Message-ID: 8C59A8CA-AEED-4443-91A3-D4D6F4D50BBA@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yes it appears to be a separate issue but using OS X is the only way I could reproduce trying to see with my own eyes so to speak
I did though a quick java program and that confirmed to me (at least so far) that the whole issue resides in the so called data object

Thank you so much for help and insight

— Armand

> On Jan 12, 2018, at 8:10 AM, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:
>
> On 1/11/18 20:52, armand pirvu wrote:
>> The -n flag worked fine on OS X. I don’t have this issue on Centos. As a side question I wonder why was postgres built with libedit instead of libreadline , just curious.
>
> You'll have to ask that of whoever built the binaries you are using.
> There are different sources.
>
> libedit is part of the macOS operating system, whereas libreadline has
> to be obtained separately, so that's probably a reason.
>
>> Back to my developer issue , he is using what he calls a data object in java. Apparently this is the place where this bad conversion happens, in other words it passes to the backend the ?? characters
>> Any similar trick I could use on the postgres jdbc driver ?
>
> That appears to be a completely separate issue.
>
> --
> Peter Eisentraut http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Keith 2018-01-13 04:39:26 Re: Updating a pre-10 partitioned table to use PG 10 partitioning
Previous Message Dylan Luong 2018-01-12 21:44:25 RE: Missing WAL file after running pg_rewind