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

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

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