On Sun, Apr 19, 2026 at 9:13 PM Igor Korot <[email protected]> wrote:
> [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. -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
