Postgres Pro
Downloads
Home   >   mailing lists

Re: How and when are encoding DLLs used on Windows? - Mailing list pgsql-admin

From David Schnur
Subject Re: How and when are encoding DLLs used on Windows?
Date
Msg-id CAANiQEmRYV2GNwSiU5b6b5YLJBNOtb+he4tBjsKEw-zymwQWsQ@mail.gmail.com
Whole thread Raw
In response to Re: How and when are encoding DLLs used on Windows?  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-admin
Tree view
On Wed, Nov 16, 2011 at 6:57 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
They're used for character set encoding conversions, eg when
database_encoding = UTF8 and client_encoding = LATIN1 (or any other
non-identical combination).

Thanks, Tom and Craig; that makes perfect sense.  I'd rather not assume anything about the client encoding, but I do know that the server encoding will always be UTF8.  Am I correct, then, in thinking that I only need the conversion procs whose names start with utf8_and...?

(I wrote this response a few days ago, but realized that I forgot to reply-all to the list)

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Upgrading DBs with type=citext from 9.0.5 to 9.1.1 using pg_upgrade and create extension
Next
From: Rob Cherry
Date:
Subject: Question on implementing ident auth correctly.