Re: JDBC prepared insert and X00 and SQL_ASCII

2020-03-19 Thread Dave Cramer
On Wed, 18 Mar 2020 at 08:56, gmail Vladimir Koković < vladimir.koko...@gmail.com> wrote: > 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

Re: JDBC prepared insert and X00 and SQL_ASCII

2020-03-18 Thread gmail Vladimir Koković
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,

JDBC prepared insert and X00 and SQL_ASCII

2020-03-16 Thread gmail Vladimir Koković
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? My environment: [root @ vlada-home ~ 16:32:56] $ psql -