Re: char 0x00

2020-03-28 Thread Brett Okken
Dave, any thoughts on best way to reproduce Vladimir’s described workflow in a way that is consumable by the postgresql team? On Thu, Mar 26, 2020 at 10:21 AM Tom Lane wrote: > Brett Okken writes: > > Using a client and server encoding of SQL_ASCII makes it possible to get > > 0

Re: char 0x00

2020-03-26 Thread Brett Okken
Using a client and server encoding of SQL_ASCII makes it possible to get 0x00 into a text value column when using a bind variable. Thanks, Brett On Thu, Mar 26, 2020 at 9:22 AM Tom Lane wrote: > Brett Okken writes: > > It might also be helpful to state in the opening paragr

char 0x00

2020-03-26 Thread Brett Okken
There was a lot of a discussion recently on a pgjdbc issue[1] started by a user who was experiencing errors trying to insert string values containing the 0x00 char into text columns. We ultimately concluded that while this could be forced to work for SQL_ASCII, postgresql does not intend to support