Re: char 0x00

2020-03-28 Thread Dave Cramer
We don't have to make it consumable. If we can use his code and reproduce it in the JDBC driver that is enough. Dave Cramer On Sat, 28 Mar 2020 at 11:31, Brett Okken wrote: > Dave, any thoughts on best way to reproduce Vladimir’s described workflow > in a way that is consumable by the postgres

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 > > 0x00 into a text

Re: char 0x00

2020-03-26 Thread Tom Lane
Brett Okken writes: > 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. Having looked at the code again, I flat out don't believe you. textin is certainly not going to read past a nul character, and textrecv goes t

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 paragraph about > charact

Re: char 0x00

2020-03-26 Thread Tom Lane
Brett Okken writes: > It might also be helpful to state in the opening paragraph about character > set support that the NUL character is not supported in any character set > (except SQL_ASCII). Uh, it's not supported *anywhere*, period. If you managed to get the server to accept a text string wi