On Fri, Aug 24, 2018 at 04:54:32PM -0400, Wietse Venema wrote: > I think that we should by default extend this to all lookup tables > and do away with that LATIN1 hack. That would also address the > problem that underlies the original request. No need for signaling > the request encoding!
If the Postgres dictionary client-encoding changes from LATIN1 to UTF8, at what layer do you want to convert "unspecified" non-ASCII lookup keys UTF8 (by encoding each non-ASCII byte to 2 UTF-8 bytes)? If we don't do that, we'll get dictionary lookup errors for invalid input strings, rather than no-match... -- Viktor.