Hi I've just noticed that the DBD::Pg documentation recommends removing any mention of the 'pg_enable_utf8' connection attribute and instead relying on the default behaviour which is based on the 'client_encoding'. What's not clear to me is how I would ensure that 'client_encoding' gets set correctly.
It looks like libpq will set the client_encoding based on the value of LC_CTYPE or PGCLIENTENCODING. Is there some way to specify the client encoding in the DBI->connect() call or should I just set the PGCLIENTENCODING environment variable before connecting? I want to use UTF8 as the client encoding, but for "reasons" (possibly relating to legacy expectations around collation order) my clients will have LC_CTYPE set to "POSIX". Ultimately, I think a POD patch to DBD::Pg is probably required since the docs currently say that client_encoding is important but don't say how to set it. Thanks Grant
