Postgres Pro
Downloads
Home   >   mailing lists

Re: JDBC prepared insert and X00 and SQL_ASCII - Mailing list pgsql-hackers

From gmail Vladimir Koković
Subject Re: JDBC prepared insert and X00 and SQL_ASCII
Date
Msg-id ec506b61-6291-837e-41bd-af6507a0dbba@gmail.com
Whole thread Raw
In response to JDBC prepared insert and X00 and SQL_ASCII  (gmail Vladimir Koković <vladimir.kokovic@gmail.com>)
Responses Re: JDBC prepared insert and X00 and SQL_ASCII
List pgsql-hackers
Tree view

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?


pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Multivariate MCV list vs. statistics target
Next
From: Mike Palmiotto
Date:
Subject: Re: Auxiliary Processes and MyAuxProc