[snip] > > In your setup all the installed encoding conversion functions are also > the default for those conversions. It is possible to create/install a > conversion function that is not the default.
So, let's say I chose "BIG5"".
As stated the table contains:
big5_to_utf8 | BIG5 | t big5_to_euc_tw | BIG5 | t big5_to_mic | BIG5 | t
Since all 3 are default character sets, which one would be chosen? (in the context of CREATE DATABASE)
Does CREATE DATABASE convert text? (I think you might be misunderstanding the purpose of the pg_conversion table.)
Wouldn't it only convert text when a client is inserting text of encoding X into a table with encoding Y?
ISTM that pg_conversion says whether PG knows how to convert from X to Y, not the encoding scheme you defined when creating the db.
