Re: JDBC prepared insert and X00 and SQL_ASCII

From: gmail Vladimir Koković <vladimir(dot)kokovic(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: JDBC prepared insert and X00 and SQL_ASCII
Date: 2020-03-18 12:56:02
Message-ID: ec506b61-6291-837e-41bd-af6507a0dbba@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

After a thorough Java-Swig-libpq test, I can confirm that INSERT/SELECT
is working properly:
1. server_encoding: SQL_ASCII
2. client_encoding: SQL_ASCII
3. INSERT / SELECT java string with x00

libpq, psql - everything is OK !

Vladimir Kokovic, DP senior (69)
Serbia, Belgrade, March 18, 2020

On 16.3.20. 17:04, gmail Vladimir Koković wrote:
>
> Hi,
>
> I don't know if this is a bug or the intended mode,
> but since ODBC works and JDBC does not, I would ask why JDBC prepared
> insert does not work if ODBC prepared insert works
> in case some varchar field contains 0x00 and DB is SQL_ASCII?
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mike Palmiotto 2020-03-18 13:22:58 Re: Auxiliary Processes and MyAuxProc
Previous Message Tomas Vondra 2020-03-18 12:36:29 Re: Multivariate MCV list vs. statistics target